Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |