Forum Discussion
dtango9
Helper II
Helper IIReplace empty cells with (Blank)
Hello. I'm looking to replace values in a column that are empty and have them return as (Blank). I have created a new column that returns the (Blank) cells, but it doesn't work for the empty ones...
parry2k
Super User
Super Userdtango9 you can try this:
New Master Name = Switch( True(),
((isblank([Originating Master Name]) or LEN(TRIM([Originating Master Name])) = 0) && containsstring([Description], "prepaid") , "PREPAIDS" ,
((isblank([Originating Master Name]) or LEN(TRIM([Originating Master Name])) = 0), "Accrual/Reclass" ,
[Originating Master Name]
)
dtango9Helper II
Helper IINeither solution worked. I think this is a similar situation that I am experiencing :
Data showing blank and null - Microsoft Fabric Community