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

Hi Anonymous

 

You might be able to use the ROW and UNION function in Excel 2013 to achieve the same result

 

=
VAR temp =
    UNION (
        ROW ( "Dates", [Creation date] ),
        ROW ( "Dates", [Start date] ),
        ROW ( "Dates", [Delivery date] ),
        ROW ( "Dates", [Verification date] )
    )
RETURN
    MAXX ( temp, [Dates] )
  • 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