Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How do I get Column "Letter due to Supervisor" to show blank date when Column "Description" has text (Letter Waived).
Solved! Go to Solution.
@inglexjc Try:
Letter Due to Supervisor Measure =
IF(
CONTAINSSTRING(MAX('Table'[Description]), "Letter Waived"),
" ",
MAX('Table'[Letter Due to Supervisor])
)
@inglexjc Maybe:
Letter Due to Supervisor Measure =
IF(
CONTAINSSTRING(MAX('Table'[Description]), "Letter Waived"),
BLANK(),
MAX('Table'[Letter Due to Supervisor])
)
@Greg_Deckler that then removes the whole row that has the information. I just want the Date to go blank but the rest of the line for the person to still be there.
@inglexjc Try:
Letter Due to Supervisor Measure =
IF(
CONTAINSSTRING(MAX('Table'[Description]), "Letter Waived"),
" ",
MAX('Table'[Letter Due to Supervisor])
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 50 | |
| 43 |