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...
Hi MungoSerge ,
The DAX language also includes functions such as AVERAGE and STDEV.P. Please refer to these links for more information.
https://learn.microsoft.com/en-us/dax/average-function-dax
https://learn.microsoft.com/en-us/dax/stdev-s-function-dax
If you need more specific assistance with the formula, as suggested by lbendlin , it would be helpful to provide some sample data.
Best Regards,
Bof