Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to duplicate the STANDARDIZE() function available in Exel in order to generate a standardized ratio, or z-score.
z= (x - m) / sd
How would I write a formula for this?
I'm assuming you have a data table that has the X and SD values, and you can calculate the population mean from the data?
I would create a measure in the following form:
Zscore =
var popMean = calculate(average(Table[Value]),all(Table)),
return (table[Value] - popMean) / table[SD]
Note: you could calculate the SD if necessary using another variable like popMean
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |