topic Re: Standard Devation in DAX Commands and Tips

Standard Devation

Kethireddy334 — Tue, 17 Jan 2023 12:08:43 GMT

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.

Re: Standard Devation

ppm1 — Tue, 17 Jan 2023 13:08:45 GMT

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

Re: Standard Devation

Kethireddy334 — Wed, 18 Jan 2023 08:47:17 GMT

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