Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Column Formula help

Dear Experts

Can someone please help me with the column formula to have Yes or No based on the Column A.

Column B to have yes if any text is available in the Column A.

 

 

Thanks in advance
Mahad

  • Anonymous 

    pls try this

    ColumnB = if('Table'[columnA]="","No","Yes")

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 

    please use

    IF ( ISBLANK ( TableName[Column A] ), "No", "Yes" )

  • Anonymous 

    pls try this

    ColumnB = if('Table'[columnA]="","No","Yes")