Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
2 years ago
Solved

Create 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" = "Cancelle...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello ADSL ,

     

    try the following calculated column

     Cancelled = IF('Visited'[Notes] = blank(), "Visited","Cancelled")

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello ADSL ,

 

try the following calculated column

 Cancelled = IF('Visited'[Notes] = blank(), "Visited","Cancelled")