Previous month 6month moving average

[adityavighne]

Hi

I have created 6MMA measure but want to display previous month 6MMA value in KPI

Can you guide me how I can do this.

e.g. July is current month then i want to display June 6MMA value

Also want to display difference % in KPI? 

e.g. June - May value

[amitchandak · Accepted solution]

@adityavighne , Try measures like

Rolling 6 till this month = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(today(),0),-6,MONTH))

Rolling 6 till last month = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(today(),-1),-6,MONTH))

Rolling 6 till 6th last month = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(today(),-6),-6,MONTH))

Rolling 6  till last month selected date = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-1),-6,MONTH))