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

Hi Anonymous  Is this your desired outcome?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi DimaMD the out come should be no date as we have missing entries for num  assoicated to ID - it need to be a complete set...the max if any need to be based on the 3 columns 

  • DimaMD's avatar
    DimaMD
    Solution Sage
    3 years ago

    Anonymous Can you provide your desired result?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi DimMD see two screen images of no max date and max date when all conditions are met

       

      • DimaMD's avatar
        DimaMD
        Solution Sage
        3 years ago

        Anonymous try it colum

        MaxDate = 
 IF( 
    [ACTDate] = BLANK(),BLANK(),
     CALCULATE( MAX('table (2)'[ACTDate]),
         FILTER('table (2)', 'table (2)'[NUM] = MAX('table (2)'[NUM] ))))