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])
)
User | Count |
---|---|
69 | |
68 | |
64 | |
54 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
43 |