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 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] ))))
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      DIMaMD -sorry not working getting a max date where Date Checj is zero as per image one

      • DimaMD's avatar
        DimaMD
        Solution Sage
        3 years ago

        Anonymous Please provide more input, everything is working correctly in my example