Forum Discussion

arumel's avatar
arumel
Frequent Visitor
2 years ago

Multi year budgets v actual

Hi all, new to power BI and need some help with the intial setup for a dashboard - Essentially this is a budget to expense report.   I have 2 fact tables:   1: Budget = Budget data is on an annua...
Need Help
arumel's avatar
arumel
Frequent Visitor
2 years ago

Hi all,

 

The above soluton works when the "Year" table is created as mentioned, however if i try and create a 'Dates' tables as a autocalendar and try and create a relatationship bertween the new 'dates' table 'Year' to the year columns in 'budget' and 'actual' tables, i get error meassages:

 

 

I would prefer a 'dates' table to to year on year comparisons ..

 

Any solutuions to these problems?

 

Thanks again

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi arumel ,

Thanks for your feedback. That's only warning message due to both of the related tables(the table 'Dates' and 'Budget') has duplicated values. You can ignore it and click "OK" button to create the relationship for them directly.

Best Regards