Forum Discussion

topazz11's avatar
topazz11
Helper III
4 years ago
Solved

DAX Max value

Hi. I thought it was easy, but somehow I can't get it to work. I have a table with 3 value columns. I want to add another Column which shows the maximum number among the 3 values columns. Tried a...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi topazz11 

     

    try this measure:

    Measure_Max Value = 
Var _A = sum('Table'[Value1])
Var _B = sum('Table'[Value2])
var _C = sum('Table'[Value3])
return
max(max(_A,_B),_C)

     

    output:

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi topazz11 

 

try this measure:

Measure_Max Value = 
Var _A = sum('Table'[Value1])
Var _B = sum('Table'[Value2])
var _C = sum('Table'[Value3])
return
max(max(_A,_B),_C)

 

output:

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!