Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Max date form different table with filter

Hi all,   I'm having issues with comparing two dates in different tables. One is a table with employee info, the other one a datetable.I I'm trying to create a measure which return True when the da...
Need Help
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

    hi,@The_Coon 

          After my research, the two formulas above is calculate column, not measure. You can use this formula to add a measure instead of the column:

    new Out of service in period = if(and(CALCULATE(MAX(Employees[Date out of Service])<>BLANK()),CALCULATE(MAX(Employees[Date out of Service])<MAX('Calendar'[Date]))),TRUE(),FALSE())

    Result:

    After I changed date

     

    Best Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
8 years ago

hi,@The_Coon 

      After my research, the two formulas above is calculate column, not measure. You can use this formula to add a measure instead of the column:

new Out of service in period = if(and(CALCULATE(MAX(Employees[Date out of Service])<>BLANK()),CALCULATE(MAX(Employees[Date out of Service])<MAX('Calendar'[Date]))),TRUE(),FALSE())

Result:

After I changed date

 

Best Regards,

Lin

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lin, you are the greatest. Worked like a charm offcourse. Thanks for helping me to start the day with a smile.

 

Koen