12 month Rolling Average

[MillarJayakumar]

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

[collinsg]

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