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.
New Master Name = Switch( True(),
isblank([Originating Master Name]) && containsstring([Description], "prepaid") , "PREPAIDS" ,
isblank([Originating Master Name]), "Accrual/Reclass" ,
[Originating Master Name]
)
4 Replies
- parry2k
Super User
dtango9 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] )
dtango9Neither solution worked. I think this is a similar situation that I am experiencing :
Data showing blank and null - Microsoft Fabric Community
