Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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??
Solved! Go to Solution.
@NNaj , 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
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
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
@NNaj , 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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |