Forum Discussion
ADSL
Post Prodigy
Post ProdigyCreate New Column with Text & Blank Value
Hi BI Community Team,
I have a table and column name "Notes" have a text value that user input and blank. With this column, we want to create a new column to identify for "text value" = "Cancelled" and "Blank value" = "Visited".
I have tired to create a new column but it's working only blank value only and still missing cancelled.
>> Cancelled = IF(LEN('Visited'[Notes]) = 0, "Visited",'Visited'[Notes])
May I need your help/advise?
Thanks and Regards,
Hello ADSL ,
try the following calculated column
Cancelled = IF('Visited'[Notes] = blank(), "Visited","Cancelled")
2 Replies
- Idrissshatila
Super User
Hello ADSL ,
try the following calculated column
Cancelled = IF('Visited'[Notes] = blank(), "Visited","Cancelled") - ADSL
