Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Previous month 6month moving average

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

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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))