Forum Discussion

Rajendrabobade's avatar
Rajendrabobade
Helper II
5 years ago
Solved

Last 3 month Average

Hello , I need last 3 month average dax , based on current month  . there is no selction for month .  eg: for now there is november is current month .    Thank you .            
Need Help
Show and Tell
Tips and Tricks
  • camargos88's avatar
    camargos88
    5 years ago

    Rajendrabobade ,

     

    If you have a date table, you can use this measure:

    _Last3M = 
VAR _today = EOMONTH(TODAY(), 0)
VAR _tbl = DATESINPERIOD('Calendar'[Date], _today, -3, MONTH)
RETURN  CALCULATE(AVERAGE('Table'[Sales]), _tbl)
manikumar34's avatar
manikumar34
Solution Sage
5 years ago

Rajendrabobade , 

 

Try something like this

6 Months Average Measure =
CALCULATE(
SUM('Sales data'[Revenue]),
DATESINPERIOD('Sales data'[weekstart],LASTDATE('Sales data'[weekstart]),-3,MONTH)
)
/
CALCULATE(
DISTINCTCOUNT('Sales data'[weekstart]),
DATESINPERIOD('Sales data'[weekstart],LASTDATE('Sales data'[weekstart]),-3,MONTH)
)
 
Regards, 
Manikumar