List.Union(lists as list, optional equationCriteria as any) as list


Takes a list of lists lists, unions the items in the individual lists and returns them in the output list. As a result, the returned list contains all items in any input lists. This operation maintains traditional bag semantics, so duplicate values are matched as part of the Union. An optional equation criteria value, equationCriteria, can be specified to control equality testing.

Reference Data

Power Query M Functions / List Functions / List.Union