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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Zubair,

 

Unfortunately the UNION function is also not accepted by Excel 2013.

 

This is the type of solution I'm thinking about:

MAXX(
        <SomeTable, dynamically created to contain four dates per row>,
        [SomeTable]
)

 

Do you have any other ideas?

Erwin

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

Anonymous

 

Can you use GENERATESERIES in Excel 2013?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Nope, just GENERATE and GENERATEALL

  • 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???>
)