Forum Discussion

MillarJayakumar's avatar
MillarJayakumar
Frequent Visitor
2 years ago

12 month Rolling Average

can any one suggest me the correct dax code for 12 month rolling average ( i try to do it but its showing incorrect result)

 

My code :-
12 Month Rolling Average = CALCULATE(AVERAGEX('DMADP OPEM_ADP_DATE_D',[Total TRs]), DATESINPERIOD('DMADP OPEM_ADP_DATE_D'[Date], MAX('DMADP OPEM_ADP_DATE_D'[Date]), -12, MONTH))
 
Just for your info
meaning of Year-Month (date type date) - Column which is newly created in PBI ( like add column)
meaning of Total TRs( data type text) - Dax query ( count(TRid))
 

 

Data Protection
Need Help
Tips and Tricks

1 Reply

  • collinsg's avatar
    collinsg
    Solution Sage
    2 years ago

    Good day MillarJayakumar,

    Alberto Ferrari of sqlbi.com provides a guide to creating a twelve month rolling average in DAX. It is here. In general DAX gurus will hang out in the Dax Commands and Tips forum, it's probably the better forum for getting fast responses on DAX queries.

    Hope this helps