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 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

       

      • 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

      does your example return no max date when you have a 0 in date Check column. if yes can you provide a PBIX Please

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Also another slight change