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,
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
222 | |
48 | |
45 | |
44 | |
42 |
User | Count |
---|---|
273 | |
211 | |
103 | |
74 | |
63 |