Check if a column values is blank and simply return Yes/N

[Anonymous]

Good morning,

i looked around and i still couldn't find a solution to something so simple.

I have a colmun where some rows have values other don't.
I need to create another column that returns Yes if there's a value, No if there's not

I tried :
if(isblank[columnName]),"True","False")
if(isblank[columnName]),true,false)

And .. no luck
Thanks for any help

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have built a simple data sample(column is Text type), please check.

• Use DAX:

Column use DAX = IF([Fonction]<>BLANK(),TRUE(),FALSE())   // or IF([Fonction]<>BLANK(),"Yes","No")

• In Power Query:

TrueOrFalse = Text.Length([Fonction])>0

Or 

YesOrNo = if Text.Length([Fonction])>0 then "Yes" else "No"

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the quick reply 🙂
I'm still gettting an error

[Jihwan_Kim]

Thank you for your feedback.

What I wrote is for calculated column, written in DAX.

Are you looking for M in Power Query?

[Anonymous]

To be honest i'm just looking for a way to have the data as yes or No lol
I thought i simple Conditionnal Column would do it but no....

[Jihwan_Kim]

Please try the below.

Another column CC =
IF ( ISBLANK ( 'tablename'[columnName] ), "No", "Yes" )