Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column using MAXX with multiple calculations as expression

Hi peeps, I have 3 columns in my table with each containing a decimal number. Now I want a column which displays a number after a calculation has been made. This column needs to display the highest ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous yes you are right my bad.

    Maximum = 
VAR _m = 'Table'[M]*1750
VAR _w = 'Table'[W]*1
VAR _v = 'Table'[V]*330
RETURN MAX(_m,MAX(_w,_v))

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

You can try adding a column like below.

Column = MAXX( { 'Table'[M] * 1750, 'Table'[W], 'Table'[V] * 330 }, [Value] )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.