Forum Discussion
Solved
Create Variable to know if value is within table column
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 Co...
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 1Replace #"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 1Replace #"Previous Step Name" with the appropriate reference (e.g. it might be #"Changed Type" or Source or #"Filtered Rows").
Thank you!!
Jacek
