Forum Discussion

StoryofData's avatar
StoryofData
Icon for Helper III rankHelper III
3 years ago
Solved

Empty Date Value

Wondering if there a smart way to do this, I have table with cases and their open and closed dates.  For the times when the case is still open, I want the card to show "Still Open", I have achieved ...
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    3 years ago

    sure 🙂

     

    Date Closed Blank = COALESCE(FORMAT(CALCULATE(MAX('Query1'[DateClosed])),"MM/DD/YYYY") , "Still Open")
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

sure 🙂

 

Date Closed Blank = COALESCE(FORMAT(CALCULATE(MAX('Query1'[DateClosed])),"MM/DD/YYYY") , "Still Open")
StoryofData's avatar
StoryofData
Icon for Helper III rankHelper III
3 years ago
For some reason, it produces a blank instead of "Still Open", meaning the card does not show anything at all. Could there be an issue?

=COALESCE(FORMAT(CALCULATE(MAX('Query1'[DateClosed])),"MM/DD/YYYY"),"Still Open")