Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

DEVSQ

In my recent quest to create or catalog as many DAX equivalents for Excel functions, this was another walk in the park:

DEVSQ = 
    VAR __Mean = AVERAGE('Table'[Column1])
    VAR __Table = 
        ADDCOLUMNS(
            'Table',
            "Deviation",POWER([Column1] - __Mean,2)
        )
RETURN
    SUMX(__Table,[Deviation])

No RepliesBe the first to reply