Forum Discussion
Solved
Check for a Column with all null values
I wat to check if an entire column has null values and if yes, add another column with value "YES NULL" else "NO NOT NULL" repeating in DAX. ISBLANK does it for every row. But I want to check the en...
Hi Hoping in general to check if column contains null, one possible solution is
Is_Null_Column =
IF(
COUNTROWS(<YourTableName>) = COUNTBLANK(<YourTableName>[YourColumnName]),
"Yes:NULL",
"No:NOT NULL"
)
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
