Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
Do we have some replacement in Power BI for =STANDARDIZE function (from Excel)
X is value in column, Mean is measure, Strandard_dev is also a measure, so we have arguments for function, how to have that as STANDARDIZE function?
Thank you
Solved! Go to Solution.
Hi @vedran
The Standardize formula in excel =
( Value to Normalize - Arithmetic Mean of the Distribution ) / ( Standard Deviation of the distribution )
Going by the formula create a measure
= (YourTable[Column X] - measureMean ) / measureStandard_dev
If this works please accept it as a solution and also give KUDOS.
Cheers
CheenuSing
Hi @vedran
The Standardize formula in excel =
( Value to Normalize - Arithmetic Mean of the Distribution ) / ( Standard Deviation of the distribution )
Going by the formula create a measure
= (YourTable[Column X] - measureMean ) / measureStandard_dev
If this works please accept it as a solution and also give KUDOS.
Cheers
CheenuSing
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |