SharePoint imported data containing blank cells not treated as blank

[ExceLover]

Hi,

I have a dataset that is a List in SharePoint, and it has has several columns. Some columns have several rows that do not contain data. This dataset was imported into Power BI from SharePoint. In Power BI, if there are any blank cells within this dataset, why does Power BI not regard these cells as actually blank?

I have attempted to create new columns that return a certain value if cells are greater than or equal to 0 and another if the cells are blank, but the results are incorrect because Power BI doesn't seem to treat empty cells as blanks.

When copying the table in Power BI and pasting into Excel and using a simple ISBLANK logic, the empty cells return FALSE.

Can anyone suggest what the best solution to this is?

Thanks

[vicky_]

It might be the type of the column - for example, if the type is a string, then blank values are treated as an empty string (""), rather than a null value. So instead of checking for ISBLANK(), you would need to check for [Field] = "".
I think this article might help: https://www.sqlbi.com/articles/blank-handling-in-dax/