Forum Discussion
Aggregation for Same Period Last Year-
Hi Everyone, I have an aggregate measure accumulating the sales as the months go on called "Actual TRG AGG" I've highlighted above the portion relating to the Aggregating eleme...
Anonymous , In the that max filter for cumulative you should use date table
filter(allselected('Date'),'Date'[date] <=max('Date'[date])
and for one year use the same calculation with
var _max = max('Date'[date])
var _date = date(year(_max), month(_max), day(_max) )
return
calculate([Actual TRG], filter(allselected('Date'),'Date'[date] <=_date ) , <Rest of the calc> )
These are my filters in case I wasn't clear amitchandak . And yes I switch from sales dates to calendar dates table.
Thanks amitchandak and tried it --> see '-1v2' below:
It gives the same as the original year. I need it to add(aggregate) so for February it would be the sum of the highlighted (371+408=779)