Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
coudl you please help me with the following.
I need to store in a coulumn the max value of other 4 calcualted columns by row
So I have in row 1
column a -> 5,4 (result of a calculation)
column b -> 3 (result of a calculation)
column c -> 9 (result of a calculation)
coulmn d -> 1 (result of a calculation)
I need to have a column e -> 9
thanks In advance
G
Solved! Go to Solution.
Others may have a cleaner solution, but I find this works:
e = MAX( [d], MAX( [c], MAX( [a], [b] )))
a b c d e
5.4 | 3 | 9 | 1 | 9 |
Regards,
thanks !!!!
Others may have a cleaner solution, but I find this works:
e = MAX( [d], MAX( [c], MAX( [a], [b] )))
a b c d e
5.4 | 3 | 9 | 1 | 9 |
Regards,