Forum Discussion
Calculate Standardize to remove data points - power pivot Z-Score
Hi all, I'm trying to build a model using Power Pivot (data is already loaded into power query). I'm having a difficult time trying to create a power pivot measure that would return what I believe i...
Omid_Motamedise
Super User
Super UserAS you whant to calculate (x-AVG)/sd you can use the below function in Dax, if your table name is X and your data in one column namely data (it would be better to unpivot your data and show them into one column, as it is harder to operate over the columns)
Z =
var AVG = calculate(average(X[data]),all(X)),
return (X[data] - AVG) / X[SD]