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.

2 Replies

  • 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