Forum Discussion

ajay_gajree's avatar
ajay_gajree
Helper I
5 years ago
Solved

Power Query M Code - Select Columns if the Header contains two specific values

= Table.SelectColumns(Source,{"51a", "51b", "51c", "51d", "51e", "51f", "51g", "51h", "51i", "51k", "Entry Id"})   Hi all   I have the above M Step, is there a way to dynamically code this so t...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, ajay_gajree 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

    Table:

     

    You may add a new step with the following m codes.

    = Table.SelectColumns(
         #"Changed Type",
         List.Combine({
         {"Entry ID"},
         List.Select(
                Table.ColumnNames(#"Changed Type"),
                each Text.Contains(_,"51")
         )
         })
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, ajay_gajree 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

 

You may add a new step with the following m codes.

= Table.SelectColumns(
         #"Changed Type",
         List.Combine({
         {"Entry ID"},
         List.Select(
                Table.ColumnNames(#"Changed Type"),
                each Text.Contains(_,"51")
         )
         })
)

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.