Sleeper: Power Query - Replace multiple values

[fb7894]

What if you add a new helper column and use and IF statment?

#"Added Conditional Column" = Table.AddColumn(PreviousStep, "Custom", each if [Column6] <> null then 1 else null)