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 advanc...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    pls try this

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

please use

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