The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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])
)