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

2 Replies

  • camargos88's avatar
    camargos88
    Community Champion
    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