Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |