Power BI - measure for previous month and last 3 months

[elyne]

Hi guys,

i am struggling with the result of counting all the animals that have the arrival date of the previous month.

I created a mesaure with following formula:

New arriving Animals last Month =
CALCULATE(COUNTROWS(pu_animals), PREVIOUSMONTH('pu_animals'[Date of Arrival]))

but it does not work. I read a few articles , not sure if I now have to create a new table for calculating relative dates. how do you do it? same with filtering 3 month.

many thanks for your help!

[MorganG]

Hoping @BCBuizer or another champ may be able to help out. It's been very quiet in responses over the past week as we're trying to complete the challenge. 

[PoornimaAilneni]

Hi @elyne 

Please check and do required modifications if needed 

CALCULATE(COUNTROWS(puc_animal),FILTER(puc_animal, puc_animal[Date of Arrival] >= TODAY() -30))

[cad17]

Also note that the data set given to us doesn't have any "arrivals" and "fosters" in the timeframe for the PU challenge, so you may be returning null or "Blank" unless you add new animals or change dates in the animal table. 

[jenhuy]

Hello! I also noticed the date discrepancy and was curious about how you handled the requirements for showing data from the previous month.

[cad17]

I used code similar to yours, but instead of using previousmonth, I used 

"pp_animalinfo[DateOfArrival]" > EDATE(TODAY(),-1) where the quote is your animal data file's column for date of arrival