Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to find out the sum of sales on the max available date of each month.
i am using the below set analysis:
SUM({<[Date]= {"=Aggr(max([Date]),[Month])"}>}[Sales])
the above expression returns the sum of sales on the first day of each month
even though Aggr(max([Date]),[Month]) returns the correct max available date of each month.
Please help
If you have month as a dimension the below shall work
SUM({<[Date]= {"$(=max([Date]))"}>}[Sales])
It gives the sum sales on the max date of the max month.
However i need the sum of sales on the max date of all the month.
I need to make a master measure like that .
Hence when put against any dimension it should give the sum of sales on the max date of each month for that dimension
as i said if you have month as a dimension the above expression shall work.
Hi,
Maybe using the Dollar Sign Expansion in your Set Analysis will help, like:
SUM({<[Date]= {"$(=Aggr(max([Date]),[Month]))"}>}[Sales])
My bad. I didn't realise what you wanted. Set analysis is calculated once per chart so taht's obvious.
your expression shall work, i tried it.
What dimension are you using? I tried with similar sample data and it's working for me.