List.ContainsAll

This function determines if all the values in one list are also present in another list. It returns "true" if a value is found in the list, and "false" if not. You can also specify an optional equatio...

Syntax

List.ContainsAll(list as list, values as list, optional equationCriteria as any) as logical

About

This function determines if all the values in one list are also present in another list. It returns "true" if a value is found in the list, and "false" if not. You can also specify an optional equation criteria value, equationCriteria, to customize the equality testing.

Explanation

Determine if the set {1, 2, 3, 4, 5} includes both 3 and 4. Usage: Power Query MList.ContainsAll({1, 2, 3, 4, 5}, {3, 4}) Output: true Determine if the set {1, 2, 3, 4, 5} includes both 5 and 6. Usage: Power Query MList.ContainsAll({1, 2, 3, 4, 5}, {5, 6}) Output: false