Get Last Month Data thru DAX

[Shubham]

Hi,

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.