Search notes:

Power Query M formula language standard library: List.Difference

In the following Power Query expression, diff is evaluated to the list {"a", "c", "b"}.
let
   L1 = {"x", "y", "z"},
   L2 = {"a", "y", "c", "x", "b"},
   diff = List.Difference(L2, L1)
in
   diff

See also

The Power Query standard library

Index