Power BI Data Modeling

Hi and good morning everyone.

I need to normalise many to many relation between Budget and actual amount.

I want to display monthly budget vs Actual by months by cost centers but, the budgets is repeating. Any help will be appreciated.
Sample Data.xlsx (110.2 KB)

Here is an idea to consider

I recommend placing a few of details into queries and maybe create a thread on convinced you’ll get a good answer to help you on this