Forum Discussion

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

Anonymous

 

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

Anonymous's avatar
Anonymous
Not applicable
7 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
    Community Champion
    7 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