reference column value from before Table.Combine step

[ImaKickUrBut]

Hello! I'm very new to PBI & need some guidance please. 

I am combining 6 excel workbooks together - each workbook has several sheets that show departments & items based on item status (intake or inventoried).

Workbook Sheets:

department1-intake, department1-inventoried, department2-intake, department2-inventoried, etc

* if departments dont have any intake or inventoried items, the sheet is not present in the workbook

the only place that the workbook shows the department & activity is in the sheet name. 

I am using Table.Combine to create a single aggrigated table from all the workbooks, but I'd like to show a column with the department and activity in the aggrigated table. What would be the best way to show which sheet (department & activity) the data came from? Could I reference the origin sheet name in a column? 

[lbendlin · Accepted solution]

yes, you can reference any of the prior steps and their data points via

#"step name"{row index}[column name]  etc.