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! Learn more
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])
  )
					
				
			
			
				Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.