Forum Discussion
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 ...
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))
Anonymous
please try below calculated column
Maximum =
VAR _m = 'Table'[M]*1750
VAR _w = 'Table'[W]*1
VAR _v = 'Table'[V]*330
RETURN MAX(a,MAX(b,c))Where does the a,b,c come from? is this supposed to be _m , _W, _V?
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))