Reply
Member
Posts: 67
Registered: ‎05-11-2016

Get Last Month Data thru DAX

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.