Dealing with budgets

Hi v-zhangti 

That's one of my Excels (I have remove a lot of rows and numbers may not have sense because they're randomly generated). I have one per year so: Budget 2023.xlsx, Budget 2024.xlsx, and so on in the same folder. Then, inside the example file there are only two centers, but normally I have over 20 centers.

Accounts are composed in this way (xxx-cc-....) where xxx are the codes for Spanish account, cc match with the center's number and the rest are generated from 1.

In Power BI, when I read all these files, I perform a merge to have only one table with this structure in columns:

• Year: which is got by reading the filename and removing "budget"
• Center: which is read from getting two first characters of the Excel sheet name.
• Accounting account
• Description
• Monthly Budget
• Daily per occupation
• Monthly per occupation

My problem is that with this structure, I cannot deal with changes in budget. For instance, if I now need to change incomes2 for center1, I will have to overwrite the value, but I don't have any possibility to keep previous value up to October. 

Is there any workaround? Or it is just impossible? I was thinking about any way of keep track of starting date for budget and the date on which is changed but I don't want to replicate all budget just for a change in a line...

I hope to have explained myself!

Thanks in advance.