Posts: 76
Registered: ‎05-11-2016

Get Last Month Data thru DAX



I am showing the trend of 3 measure values for last 12 months, but user want to know the % of last current month data as well.

Then I used below DAX functions which helped me not to write one more sql code.


CALCULATE(SUM('Total Open'[Opened]) ,FILTER(ALL('Total Open'[Month]), 'Total Open'[Month] = MAX ('Total Open'[Month])) )


I used this code for all 3 measure seperately and then use "100% Stacked Column Chart" to display.