Forum Discussion

Kethireddy334's avatar
Kethireddy334
New Member
3 years ago

Standard Devation

I have 3 months rolling average. I need to Calculate Standard Devation for 3 months rolling average. I'm using custom calender. Please, help on this.
ppm1's avatar
ppm1
Solution Sage
3 years ago

Here's a measure expression that shows one way to do it.

SD P3M =
VAR vMaxDate =
    MAX ( 'Date'[Date] )
VAR tP3M =
    CALCULATETABLE (
        ADDCOLUMNS ( VALUES ( 'Date'[YearMonth] ), "cTotSales", [Total Sales] ),
        ALL ( 'Date' ),
        'Date'[Date] <= vMaxDate
            && 'Date'[Date]
                >= EOMONTH ( vMaxDate, -3 ) + 1
    )
RETURN
    IF ( COUNTROWS ( tP3M ) = 3, STDEVX.S ( tP3M, [cTotSales] ) )

Pat

 

  • Kethireddy334's avatar
    Kethireddy334
    New Member
    3 years ago

    Hi Pat,

    Thanks for your reply but It's not working.

    Mavg("Fact table"."TRX_VALUE_USD"/1000000,3)-STDDEV(Mavg("Fact table"."TRX_VALUE_USD"/1000000,3))

    this one created in OAC, I need to create same thing dax. Please, help me on this.

    Thanks