Select Columns based on Excel Table | Power Query

If you want to get the columns based off an Excel Table, you'll have to edit the M code.

Change the part inside the Curly Brackets { }, and put it your reference table.

For your reference table, you have to drill down on the column, so it changes into a List.

[bhuvaneshbabu]

Awesome.. I spent a whole night figuring out this. This was great. Thank you bro.

[lordtyranus]

Neat, this is exactly what I needed. Thanks so much!

[RakeshRTVM]

Fantastic. This helped me so much. The explanation was so detailed though it was a short video. Could I ask you a question ?

I wanted to aggregate (sum) selected columns from the HeaderList. How can I do that?

Thank you so much again.

[swjxgig]

Hello. how create a multiples columns based on list in excel or dynamics?

[SamehRSameh]

When I used Distinct Count in dax i want appear in total averge ? How

[veenajha]

I am not getting the transform data option post loading and Excel file. I get only load, edit and cancel as option.

Please assist me .

[vishnuvardanatmakuri]

good trick, please improve voice recording.

[noonwalker]

The audio is not comfortable to listen