Skip to main content

Power BI

Declined

Add Text.ContainsAny([Column],{List}) Function to Power Query

Vote (4) Share
's profile image

on 15 Mar 2017 17:59:05

There is Text.Contains () , List.ContainsAny () but not Text.ContainsAny () function in PQ.

Text.ContainsAny () would save loads of OR clauses with Text.Contains!

Administrator on 10 Jun 2021 18:31:09

This function would be redundant with the List.ContainsAny function - from the example this would appear to just change the position of the functions arguments.