Power BI Data Modeling

Power BI
1

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)

2

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

IMG_8131
IMG_81312732×2048 766 KB