Forum Discussion
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...
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.