Table.ExpandTableColumn M code/query

[se2]

Hello,

Is it possible to take the following, taken from the Advanced Editor in Power BI Desktop, and turn it into a function that I could then ivoke, as I use this line many times in my queries.  (I thought I posted this yesterday but I don't see it anywhere.)  Thank you, SE

I can't figure out to use a "=>" with this.

#"Expanded table.Data" = Table.ExpandTableColumn(#"Kept First Rows", "table.Data", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8"}, {"table.Data.Column1", "table.Data.Column2", "table.Data.Column3", "table.Data.Column4", "table.Data.Column5", "table.Data.Column6", "table.Data.Column7", "table.Data.Column8"}),

[dax]

Hi @se2 

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[amitchandak]

@se2 , refer if these can help

https://eriksvensen.wordpress.com/2019/10/05/powerquery-control-the-expand-columns-so-it-includes-ne...

https://datachant.com/2017/02/07/power-bi-pitfall-9/

https://www.youtube.com/watch?v=wG3J8lO9d5I

[se2]

I am studying these.  Thank you. SE

[parry2k]

@se2 what you are trying to achieve?

[se2]

I am importing an Excel file.  I find myself using one of the power query steps, over and over, so would like to convert this to a function that I can invoke.  The step is but I can't figure out how or where to use variables to convert the follow to a function that I can use add column and invoke custom with.  Thank you SE

#"Expanded table.Data" = Table.ExpandTableColumn(#"Kept First Rows", "table.Data", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8"}, {"table.Data.Column1", "table.Data.Column2", "table.Data.Column3", "table.Data.Column4", "table.Data.Column5", "table.Data.Column6", "table.Data.Column7", "table.Data.Column8"}),