Skip to main content
Microsoft Idea

Power BI


Create an optional "Ignore If Not Found" argument and optional "Use Wildcards" argument in M functions Table.TransformColumns and Table.TransformColumnNames to make dynamic transformations intuitive

Vote (1) Share
C L's profile image

C L on 22 Apr 2022 16:49:24

In the funtions Table.TranformColumns and Table.TransformColumnNames that take a list of column names as an argument:

Optionally ignore column names not found rather than erroring and optionally use wildcards * and ? in column names.

(Natively in the functions.)

Table.TranformColumns and Table.TransformColumnNames are two of the most common transformations applied automatically and through the GUI. Column names can be specified more dynamically using list transformations, but this is a common enough need in handling variable data inputs that it should be available more intuitively.