Forum Discussion

kawthergharbi's avatar
kawthergharbi
New Member
9 years ago

Personalized measure

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 :(

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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