Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
i have table with column "Col3" and i can have there nulls or some string.
And what i want to check if in Col3 there is everywhere "null" and put it into variable.
Something like if Col3.Contains only nulls then 1 else 0. (so if 1 row is different than null - put 0).
How can i do this?
I am using Power Query, not power BI.
Please help,
Jacek
Solved! Go to Solution.
You can add a custom column that references the entire column by writing #"Previous Step Name"[Col3].
if List.NonNullCount(#"Previous Step Name"[Col3]) = 0 then 1 else 1
Replace #"Previous Step Name" with the appropriate reference (e.g. it might be #"Changed Type" or Source or #"Filtered Rows").
You can add a custom column that references the entire column by writing #"Previous Step Name"[Col3].
if List.NonNullCount(#"Previous Step Name"[Col3]) = 0 then 1 else 1
Replace #"Previous Step Name" with the appropriate reference (e.g. it might be #"Changed Type" or Source or #"Filtered Rows").
Thank you!!
Jacek
Check out the July 2025 Power BI update to learn about new features.