Merge files keeping additional created columns

[nok]

Hi!

I'm racking my brain over something I thought would be simple. These are all the files I have inside a sharepoint folder(they all have the same structure, only the row values ​​change):

In this initial step of my PowerQuery, I needed to create two new columns:

1. "FileDate" column (coming from the column "Name").
2. "Year.Quarter" column (based on the "FileDate" column).

This two columns allows me to filter only the files I need to merge to create a single table. However, when I click the merge files icon in the "Content" column (marked in red in the image), PowerBI merges only the rows of the files I need, but without the "FileDate" and "Year.Quarter" columns I created earlier. Not even the "Name" column, with the origin file names, appears. If it were present in these merged tables, I could create "FileDate" and "Year.Quarter" columns again, but it doesn't appear, and I can't tell which file each row in my merged table belongs to.

How can I create a merge of the tables that maintains the "FileDate" and "Year.Quarter" columns I needed to create in the steps prior to this merge?

[GeraldGEmerick · Accepted solution]

@nok In your Applied Steps area, look for a Removed Other Columns step. Click the gear icon and select the other columns that you want to include and not be removed.