QUERY - DAX code for Exponential Moving Average calculation - EMA

[Syndicate_Admin]

Hello PBI community.

Any experts to guide me on how to break down the DAX code to calculate the Exponential Moving Average for 30 days?

Thanks a lot

RJRO

[Anonymous · Accepted solution]

HI @RAFAJRO,

You can create a variable to store the current axis date and use it as conditions to filter on your fact table records and get rolling average based on specific date ranges.

formula =
VAR currdate =
    MAX ( Calendar[Date] )
RETURN
    CALCULATE (
        AVERAGE ( Table[Amount] ),
        FILTER ( ALLSELECTED ( Table ), [Date] >= currdate - 30 && [Date] <= currDate )
    )

Regards,

Xiaoxin Sheng