Power Query: Custom Column to indicate which table data came from

[cr731]

I am using Power Query to consolidate multiple tables that are identical except they represent different data (such as one table for Actuals, one for Budget, etc.). I want to consolidate these two tables, but I need an extra column to indicate which table each row came from, to distinguish Budget versus Actuals.

Can a custom column in Power Query show me which table the row's data came from?

 

[ImkeF]

Once you've loaded your first table (Actuals), perform this last step before finishing: Add custom column named "Act/Bud" and fill in "Actuals".
Do the same with your Budget table: "Act/Bud" and "Budget".
Then append your actuals to your budget (in Combine)

LinkToFile