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

[vishnuprashanth]

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<V<14,4	2550	3000
21/05/2018	A	14,4<V<19	1500	1300
21/05/2018	A	19<V<24	200	170
21/05/2018	A	24<V<30	150	75
21/05/2018	A	30>	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<V<14,4	4550	2550
21/05/2018	B	14,4<V<19	1300	1500
21/05/2018	B	19<V<24	200	200
21/05/2018	B	24<V<30	150	150
21/05/2018	B	30>	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? 

[Phil_Seamark · Accepted solution]

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) 

[MotzWanted]

Is it also possible to do it as a measure instead of a column? Thus, it's getting normalised according to my current filter selection and always showing at least one record scoring 1.

[vishnuprashanth]

Thanks, phil. That helps.