cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vedran
Frequent Visitor

replacement for =STANDARDIZE function (from Excel)

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

 

1 ACCEPTED SOLUTION
CheenuSing
Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
CheenuSing
Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors