Trying to do this power query!

[Anonymous]

Hi All, 

I have this DAX code 

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

Trying to implement it into Power Query rather than DAX measure. Can anyone help?? 

[amitchandak · Accepted solution]

@Anonymous , You have

https://docs.microsoft.com/en-us/powerquery-m/table-min

https://docs.microsoft.com/en-us/powerquery-m/table-max

and

https://docs.microsoft.com/en-us/powerquery-m/list-max

https://docs.microsoft.com/en-us/powerquery-m/list-min

seeif these can help

[tex628 · Accepted solution]

Change the #"Changed Type" reference to the previous step in your query and try this:

([Performance] - 
List.Max(Table.Column( #"Changed Type" , "Performance" )))
/ 
(List.Max(Table.Column( #"Changed Type" , "Performance" )) - 
List.Min(Table.Column( #"Changed Type" , "Performance" )))

/ J

[amitchandak · Accepted solution]

@Anonymous , You have

https://docs.microsoft.com/en-us/powerquery-m/table-min

https://docs.microsoft.com/en-us/powerquery-m/table-max

and

https://docs.microsoft.com/en-us/powerquery-m/list-max

https://docs.microsoft.com/en-us/powerquery-m/list-min

seeif these can help