Select the Max Value between 4 Cells

Question

Dear,&nbsp;I have the following data table:&nbsp;CURRENT STATE&nbsp; &nbsp; &nbsp; &nbsp;DATE1&nbsp; &nbsp; &nbsp; &nbsp; DATE2&nbsp; &nbsp; &nbsp; &nbsp;DATE3On-going&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; May 21&nbsp; &nbsp; &nbsp; &nbsp;Jun 21&nbsp; &nbsp; &nbsp; &nbsp;Ago 21Late&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;APR 20&nbsp; &nbsp; &nbsp; &nbsp;Jun 20[Blank]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;APR 20&nbsp; &nbsp; &nbsp; &nbsp;Jun 20On-going&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb 21&nbsp;&nbsp;I would like to have a new column that take the max value between DATE1, DATE2 and DATE3 when CURRENT STATE is not Empty, so:&nbsp;CURRENT STATE&nbsp; &nbsp; &nbsp; &nbsp;DATE1&nbsp; &nbsp; &nbsp; &nbsp; DATE2&nbsp; &nbsp; &nbsp; &nbsp;DATE3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;New ValueOn-going&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; May 21&nbsp; &nbsp; &nbsp; &nbsp;Jun 21&nbsp; &nbsp; &nbsp; &nbsp;Ago 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ago 21Late&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;APR 20&nbsp; &nbsp; &nbsp; &nbsp;Jun 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jun 21[Blank]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;APR 20&nbsp; &nbsp; &nbsp; &nbsp;Jun 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Blank]On-going&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb 21&nbsp;Thank you!!!!&nbsp;LD&nbsp;&nbsp;

stevedep · Accepted Answer

Something like this;
&nbsp;
Max Value =
VAR ValueTable =
UNION(
&nbsp;&nbsp; ROW(“Value”,SUM(Data[Revenue])),
&nbsp;&nbsp; ROW(“Value”,SUM(Data[Revenue])),
&nbsp;&nbsp; ROW(“Value”,SUM(Data[Revenue])),
&nbsp;&nbsp; ROW(“Value”,[Measure1])
)
RETURN
MAXX(ValueTable,[Value])

Forum Discussion

Select the Max Value between 4 Cells

1 Reply

Related content

Display Selected and not selected values

Parameter: Selected Value doesn’t updated

Parameter: Fields selected value

Fabric Notebook ExitValue how to select specific values

Show only selected Company value