Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 this using two measures:
Solved! Go to Solution.
sure 🙂
Your approach will only work when [Date Closed] is of type text.
You can use COALESCE
Thank you! So there is no way to have only one measure to achieve this?
sure 🙂
Ah, right, I remember. There is a bug in FORMAT that happily returns an empty string instead of BLANK().
Oh well, back to your version.
=IF(ISBLANK(MAX('Query1'[DateClosed])),"Still Open",FORMAT(MAX('Query1'[DateClosed]),"MM/DD/YYYY"))
Thank you! Works now!
And, interesting, I guess that bug can be used to our advantage in some cases
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |