Merge excel sheets and keep created columns(Formula)

[Crav888]

Hi,

I want to add a new sheet of data to my Power BI each month. 

I found out how to merge excel sheets in Power BI.

But I am unsure about how I change the data source so it points towards the merged file, as it only seems to live in Power BI.

So I have data from January, where I have done some calculations etc.

Now I want to add the February data. 

[Greg_Deckler]

Are you merging or appending?

[Crav888 · Accepted solution]

I go to:

Get data->More->File->Folder->Folder path

I have my two files in there.

So I end up with one sheet titled the folder path name.