Forum Discussion
pshetty05
Helper I
Helper IHow can I get an additional column that displays the source table name after appending two tables
Hi @poTeam, I'm trying to append two different table here which has data from 2019 and 2020. I'm appending the data from both these table into one table. While I'm doing this, I'm interested to k...
pshetty05 , Do this in Data Transformation/Edit Query mode, Add a custom column with a static value of the year and then append
Refer this option too
https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
amitchandak
Super User
Super Userpshetty05 , Do this in Data Transformation/Edit Query mode, Add a custom column with a static value of the year and then append
Refer this option too
https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi
https://radacad.com/append-vs-merge-in-power-bi-and-power-query