calculated column with Isblank

[Anonymous]

Hi,

This is my dummy data but actually, I want to work on a huge dataset.

GPP is a calculated column. If the Description column is blank then "NO" else "YES".

I tried to use If ISBlank function but sometimes it gives correct output sometimes not. 

[v-deddai1-msft]

Hi @Anonymous ,

As mentioned by Nathaniel_C, maybe you have space in column,please try the following : 

GPP1 = IF(MAX('Table'[Descriptions]) =" " || ISBLANK(MAX('Table'[Descriptions])),"No","Yes")

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

Best Regards,

Dedmon Dai

[PhilipTreacy]

Hi @Anonymous 

How exactly does that formula not work?  You need to be specific and show the incorrect results.  The formula works fine for me even woth a cell that just contains spaces.

If you can share some actual, real data, specifically the data that gives the incorrect result, that would help.

regards

Phil

[Nathaniel_C]

Hi @Anonymous ,

Try this

GPP = IF(MAX('Table'[Descriptions]) ="","No","Yes")

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Anonymous]

@Nathaniel_C

Thank you for your help! The formula doesn't give the correct answer sometimes.

[Nathaniel_C]

Hi @Anonymous ,
It is possible that the cell is not empty, so for instance if there was a space in the cell.  Is there any way to check that in your data?
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[amitchandak]

@Anonymous , New column

Is Blaknk = if(isblank([description]) , "Yes" ,"No")

Not is blank  = if(isblank([description]) , "No" ,"Yes")