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?
