Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Gianfranco
New Member

Max of calculted colums

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

1 ACCEPTED SOLUTION
rsbin
Super User
Super User

@Gianfranco ,

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,

View solution in original post

2 REPLIES 2
Gianfranco
New Member

thanks !!!! 

rsbin
Super User
Super User

@Gianfranco ,

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,

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.