Personalized measure

[kawthergharbi]

I'm a beginner with power bi I'm trying to define a Personalized measure that calculates the 20-day moving average of a value. That value is a column "cloture" of the table 'historique'

Here is the expression DAX : 

MMA20 = CALCULATE(AVERAGE(Historique[cloture]); DATESINPERIOD(Historique[Date].[Jour]; DATE(2017, 02 ; 17); -20 DAY))

 Help Please 😞

[v-yulgu-msft]

Hi @kawthergharbi,

Please try this formula to create a calculated column:

Moving average =
CALCULATE (
    SUM ( Historique[Cloture] ),
    FILTER (
        Historique,
        Historique[Date] <= EARLIER ( Historique[Date] )
            && Historique[Date] >= DATEADD ( Historique[Date].[Date], -20, DAY )
    )
)
    / 20

Best regards,
Yuliana Gu