Posted on by Olly

Happy Power Query Christmas

(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"

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.