Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Trend average for 3 months

Hi all,   I want average of current 3 months, eg : Jan, Feb, March   And I want average of previous 3 months, eg : Dec, Jan, Feb   Can you suggest Dax measure for this   Please Help
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , A measure like this with help from date table

     

    Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),0) ,-3,MONTH))

     

    or

     

    Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],eomonth(today(),0) ,-3,MONTH))

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous TRy this measures:

Rolling  Avg. Last 3 Month = CALCULATE(Average(Table[NumericColumn]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

Rolling Avg. Current 3 Month = CALCULATE(Average(Table[NumericColumn]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),3,MONTH))