Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculate max date over multiple dates in a row

Hi all,   Please review below table, called "Requests".   I need to calculate, for each individual row in the table, the largest value / newest date of the columns [Creation date], [Start d...
Need Help
Show and Tell
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

 

The old fashioned way should work

 

=
MAX (
    MAX ( MAX ( [Creation date], [Start date] ), [Delivery date] ),
    [Verification date]
)

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

 

Max takes only 2 arguments. So we have to nest them

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Zubair,

     

    Still doesn't work. In your example you are still putting four dates in one MAX function, which is not allowed.

     

    I'm trying to calculate over a dynamic table using MAXX and ROW, but I can't seem to work what the expression should be (argument 2 of MAXX).

     

    =MAXX( 
            ROW(
                      "Create",MAXX(VALUES(Requests[Request]),Requests[Creation date]),
                      "Start",MAXX(VALUES(Requests[Request]),Requests[Start date]),
                      "Deliver",MAXX(VALUES(Requests[Request]),Requests[Delivery date]),
                      "Verify",MAXX(VALUES(Requests[Request]),Requests[Verification date])
            ),
            <What goes here???>
)

     

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      8 years ago
      Hi

      I am not putting 4 values in one function
      Please take a look carefully

      I am taking max of max of max with 2 columns in each