![]()
(Names, Behaviours) => let #"Make List" = Table.FromColumns({Names,Behaviours}, {"Name", "Behaviour"}), #"Check Once" = Table.SelectRows(#"Make List", each ([Behaviour] <> "Naughty")), #"Check Twice" = Table.SelectRows(#"Check Once", each ([Behaviour] = "Nice")), #"Santa Claus" = if Table.RowCount(#"Check Twice") > 0 then "is coming to town" else null in #"Santa Claus"
Bookmarks