cancel
Showing results for
Did you mean:
Member

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.

 Date Player Attribute Expected Performance 21/05/2018 A Energie 45000 52000 21/05/2018 A Distance 15000 14000 21/05/2018 A V<8 3250 2300 21/05/2018 A 8 65 10 21/05/2018 A Acc 20 25 21/05/2018 A Dec 35 32 21/05/2018 B Energie 46000 45000 21/05/2018 B Distance 15500 15000 21/05/2018 B V<8 3550 3250 21/05/2018 B 8 65 65 21/05/2018 B Acc 20 20 21/05/2018 B Dec 35 35

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

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

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) ```

Proud to be a Datanaut!

2 REPLIES 2
Microsoft

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

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) ```

Proud to be a Datanaut!

Member

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

Thanks, phil. That helps.

Announcements

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?

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

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