Forum Discussion

elz's avatar
elz
Advocate II
10 years ago

Check for null in conditional column

Hi, I am trying to create a conditional column for a date/time field and need to check to see if the field is null.   What should I enter in the Value field on the Add Conditional Column dialog bo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi -

If you right click on the column that contains null values > Replace Values > Change null to a new text (for example I used "OS is Blank" > Then run the conditional column against your new text value... the query will work.

 

#"Replaced Value" = Table.ReplaceValue(#"Removed Columns4",null,"OS is Blank",Replacer.ReplaceValue,{"computer.operatingSystem"}),

 

- Ryan