Power Query M , multiple sheet combine, add sheet name as new column to each corresponding table

Question

hi experts,&nbsp;i have action is combine 10+ sheet table in one Excel， the sheet name is contain "year" info, like the sheet name is "2018". but in the table of sheet is not have year column.&nbsp; &nbsp;so i need extract the sheet name to table's column.&nbsp; i know there expand table will keep the sheet name for every sheet table, BUT ,&nbsp; there's some special reason, i need add the column first&nbsp; for every table before expand.&nbsp;I think there should&nbsp; some M function or expression can do, but i have no idea. could yo help me ?&nbsp; &nbsp;thank you very much!&nbsp;

wdx223_daniel · Accepted Answer

NewStep=#table(Table.ColumnNames(PreviousStepName),Table.ToList(PreviousStepName,each {_{0},Table.AddColumn(_{1},"Year",(x)=&gt;_{0})}))

Forum Discussion

Power Query M , multiple sheet combine, add sheet name as new column to each corresponding table

2 Replies

Related content

Sumif of multiple corresponding values

Power Query Combine Multiple Files From Folder

Tables combine

Combine values from multiple rows

Combine columns with corresponding names