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?

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Dima MD - i modified your PBIX and see image the measure does not work now... NUM 344 should return zero max date but we have a value