replacement for =STANDARDIZE function (from Excel)

[vedran]

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

[Anonymous · Accepted 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