Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column - MAX Completion date based on 3 columns

Hi Experts   I am trying to work out the max completion date if all three conditions are met. See sample date    I need to work out the latest work completion date Based on ID and NUM columns - t...
Need Help
  • DimaMD's avatar
    DimaMD
    3 years ago

    Anonymous Is this it?

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

Anonymous Ok, then you just need to remove the IF condition

MaxDate = 
         CALCULATE(
            MAX('table (2)'[ACTDate]), 
                FILTER( 'table (2)',
                'table (2)'[NUM] = MAX('table (2)'[NUM]) && 'table (2)'[ID] = 'table (2)'[ID]
            )
        )

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

i DimaMD

 

We ahve no ACTDate and a zero in Date Check the MAx date should be blank() see image below not 29.09.21

 

  • DimaMD's avatar
    DimaMD
    Solution Sage
    3 years ago

    Anonymous Is this it?