Forum Discussion

LD's avatar
LD
Frequent Visitor
5 years ago
Solved

Select the Max Value between 4 Cells

Dear,   I have the following data table:   CURRENT STATE       DATE1        DATE2       DATE3 On-going                  May 21       Jun 21       Ago 21 Late                           APR 20   ...
  • stevedep's avatar
    stevedep
    5 years ago

    Something like this;

     

    Max Value =
VAR ValueTable =
UNION(
   ROW(“Value”,SUM(Data[Revenue])),
   ROW(“Value”,SUM(Data[Revenue])),
   ROW(“Value”,SUM(Data[Revenue])),
   ROW(“Value”,[Measure1])
)
RETURN
MAXX(ValueTable,[Value])
stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
5 years ago

Something like this;

 

Max Value =
VAR ValueTable =
UNION(
   ROW(“Value”,SUM(Data[Revenue])),
   ROW(“Value”,SUM(Data[Revenue])),
   ROW(“Value”,SUM(Data[Revenue])),
   ROW(“Value”,[Measure1])
)
RETURN
MAXX(ValueTable,[Value])