Create a rule to show If a column contains text or not

[jondarcy]

Hi All

I have created a report in desktop and I want to add a column (Column B) to show if the column next to it (Column A) contains text or not and return a yes/no response. I tried isblank and a conditional column, but I can't get the right result.

Thanks in advance

[Fowmy]

@jondarcy 

Try
= if [Column A]=null or [Column A]="" then "Yes" else "No"

[jondarcy]

Thank you, I tried that and still can't get it to work. I'm clicking Modeling>New Measure then:

1. Column B=

2.= if [Column A]=null or [Column A]="" then "Yes" else "No"

[Fowmy · Accepted solution]

@jondarcy 

You posted this question under Power Query, so I provided a PQ solution. It seems you need to add a column to your table using DAX, Go to you table, and add a new column 

Add this code:

Check Blank = IF(  OR( ISBLANK([Column A])  , [Column A]="") , "Yes" , "No" )

[jondarcy]

Brilliant, thank you 

[Einomi]

Hi @jondarcy 

Please can you be more specific and let us know how your data looks like and the desired outcome. You are welcome to attach screenshots

Looking forward

[jondarcy]

• I'm trying to do something similar to the above in PowerBI. I have a column, some rows have text, some don't and I just want to add a column to identify the rows which do/don't have text in them by returning a Yes/No response