List.Union

Accepts a list of lists as input, combines the elements within each list, and returns them as a single output list. This function ensures that all elements from the input lists are included in the out...

Syntax

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

About

Accepts a list of lists as input, combines the elements within each list, and returns them as a single output list. This function ensures that all elements from the input lists are included in the output list, following the traditional bag semantics where duplicate values are retained. Additionally, an optional parameter called equationCriteria can be defined to customize the way equality is determined during the merging process.

Explanation

Incorporate a combination of the sets {1 to 5}, {2 to 6}, and {3 to 7} with the help of Power Query MList.Union function as shown below: MList.Union({{1 to 5}, {2 to 6}, {3 to 7}}) The result of this operation will be: {1, 2, 3, 4, 5, 6, 7}