Using Standard Deviation in Power BI

[ojt1]

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.

[ojt1]

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.

[ojt1]

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)

[ray_aramburo]

Check the DAX documentation to see which one suits you the best as there are several formulas. 

Check the left panel for more: