Add identifier column before appending queries

[PowerBiKing]

Hi,

I'm bringing a PDF into Power BI that contains 3 tables that I would like to append to create one "master" table. All of the columns match up, and I can append the data as needed with no issue. However, I need a column in the new "master" table that identifies each row's source table.

I want to add a column called "Source" to the query for each of the source tables, of which every value will correspond to that source. E.g. the every value in the "Source" column in Table 1 of 3 will be "Table 1" etc. My thinking is that when I append the 3 tables, I will be able to differentiate which table the data originally came from using the "Source" column.

I'm relatively new to this, so I may be missing something obvious but I'm struggling to do this, as there doesn't appear to be a way to add a column with manual values to a table?

I should add that I can't add the identifying column before processing as I am not the publisher of the PDF, and it is updated weekly.

Example of the logic:

Table 1

Source (to add)	2021 Value	2022 Value
Table 1	345	546

Table 2

Source (to add)	2021 Value	2022 Value
Table 2	456	123

Master/appended table

Source (to add)	2021 Value	2022 Value
Table 1	345	546
Table 2	456	123

Thanks

[BA_Pete · Accepted solution]

Hi @PowerBiKing ,

I may be missing something here, but can't you just add a new custom column to each query with the calculation = "Source 1/2/3" ?

Pete

[PowerBiKing]

Ah yes thank you!

When I tried this earlier I couldn't get it to work (think I missed off the quotations) and I assumed that you couldn't just hard code it.