Forum Discussion

ojt1's avatar
ojt1
Frequent Visitor
3 years ago

Using Standard Deviation in Power BI

Hi

I have been using the following in Excel for a while to use standard deviation (as a rating as opposed to a ranking such as %rank):

=($DM2-AVERAGE($DM:$DM))/STDEV($DM:$DM)

 

I have been trying to recreate in DAX (or even query) and struggling to find solutions online. I have created measures for both Average and STdev(for the columns) to use in an expression, but can't seem to solve it or find the right type of Dax expression.

I don't need the exact forumla from excel creating, just a way of measuring Stdev from the mean for each row.

 

Any help would be appreciated - thank you.

Need Help

3 Replies

  • ojt1's avatar
    ojt1
    Frequent Visitor
    3 years ago

    I have used that for the measure, but once StDev has been created (as a measure or otherwise) I am haing trouble creating an expression to use the calculated StDev in the way I have previously (the formula that I pasted from excel)

  • ojt1's avatar
    ojt1
    Frequent Visitor
    3 years ago

    Update - I have created the first half of the formula as a calculated column (Col1 lets say), but am now having trouble dividing the new column with a measure ([standard deviation]). Is it possible to do that?

    The Expression I have tried is

    NewColumn = Divide('table1'[col1],[standard deviation],0) 

    But this will only return 0.

    Any help would be appreciated, thanks.