Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
iDataDrew
Advocate IV
Advocate IV

How to duplicate the Excel STANDARDIZE() function in DAX to generate normalized ratio?

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?

1 REPLY 1

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

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.