The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
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
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
Proud to be a Super User!
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
Proud to be a Super User!
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
Proud to be a Super User!
@Anonymous , New column
Is Blaknk = if(isblank([description]) , "Yes" ,"No")
Not is blank = if(isblank([description]) , "No" ,"Yes")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |