Forum Discussion
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 ...
sure 🙂
Date Closed Blank = COALESCE(FORMAT(CALCULATE(MAX('Query1'[DateClosed])),"MM/DD/YYYY") , "Still Open")
Your approach will only work when [Date Closed] is of type text.
You can use COALESCE
Date Closed = FORMAT(CALCULATE(MAX('Query1'[DateClosed])),"MM/DD/YYYY")
Date Closed Blank = COALESCE([Date Closed] , "Still Open")
Thank you! So there is no way to have only one measure to achieve this?
sure 🙂
Date Closed Blank = COALESCE(FORMAT(CALCULATE(MAX('Query1'[DateClosed])),"MM/DD/YYYY") , "Still Open")Thank you!
