cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Normalise the data in a column between 0-1 and find the mean value using date

I have the dataset as shown below. I am trying to plot a radar chart with this data. Since the data is not normalized, the attribute with least values is centered in my chart. So, I thought of normalizing this data would give me better results. 

DatePlayerAttributeExpectedPerformance
21/05/2018AEnergie4500052000
21/05/2018ADistance1500014000
21/05/2018AV<832502300
21/05/2018A8<V<14,425503000
21/05/2018A14,4<V<1915001300
21/05/2018A19<V<24200170
21/05/2018A24<V<3015075
21/05/2018A30>6510
21/05/2018AAcc2025
21/05/2018ADec3532
21/05/2018BEnergie4600045000
21/05/2018BDistance1550015000
21/05/2018BV<835503250
21/05/2018B8<V<14,445502550
21/05/2018B14,4<V<1913001500
21/05/2018B19<V<24200200
21/05/2018B24<V<30150150
21/05/2018B30>6565
21/05/2018BAcc2020
21/05/2018BDec3535

 

Normalize the data in the 2 columns(Expected and Performance). 

I tried to use 

Normalized_performance = ('table'[Performance] - MIN('table'[Performance])/(MAX('table'[Performance]) - MIN('table'[Performance])))


But this normalization technique doesn't work as I expected. Is there any way I could normalize the data between 0-1? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Phil_Seamark
Microsoft

Re: Normalise the data in a column between 0-1 and find the mean value using date

HI @vishnuprashanth

 

I created the following calculated column which I made sure I formatted to multiple decimal places.

 

Column = 
VAR Xi = 'Table1'[Performance]
VAR MnX = MIN('Table1'[Performance])
VAR MxX = MAX('Table1'[Performance])
RETURN DIVIDE(Xi-MnX , MxX - MnX) 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Microsoft Phil_Seamark
Microsoft

Re: Normalise the data in a column between 0-1 and find the mean value using date

HI @vishnuprashanth

 

I created the following calculated column which I made sure I formatted to multiple decimal places.

 

Column = 
VAR Xi = 'Table1'[Performance]
VAR MnX = MIN('Table1'[Performance])
VAR MxX = MAX('Table1'[Performance])
RETURN DIVIDE(Xi-MnX , MxX - MnX) 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Re: Normalise the data in a column between 0-1 and find the mean value using date

Thanks, phil. That helps. 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors