AVEDEV Function equivalent in DAX?

[dapm11]

Hello All,

I'm hoping some may be able to help, I'm looking to create a DAX measure that replicates the AVEDEV (excel function).  I want to find the AVEDEV of the "Fail Rate 2" measure with an average taken for the previous 180 days.

Thank you,

D

[johnt75]

Try

Ave dev =
VAR Avg180Days =
    AVERAGEX (
        WINDOW (
            -179,
            REL,
            0,
            REL,
            ALL ( 'Date'[Date] ),
            ORDERBY ( 'Date'[Date], ASC )
        ),
        [Fail Rate 2]
    )
VAR CurrentFailRate = [Fail Rate 2]
VAR RESULT =
    ABS ( CurrentFailRate - Avg180Days )
RETURN
    Result