Standard Devation

[Kethireddy334]

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]

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]

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