I have the following tables
MonthlyBalances
AllBudgets
Scenario
Calendar
MonthlyBalances and AllBudgets are linked to the Calendar table via a DateKey - see picture attached
I've tried to recreate the scenario as per excelcraft . com Actual vs Budget but it keeps asking me for a relationship and doesn't show the correct data when using columns from the Calendar table as a filter
Any ideas what is wrong with these relationships?
The pivot uses
[ReportGroup].[Group Name]
[ReportGroup].Actual vs Budget
This works fine until I add the Slicer for from the Calendar
Bookmarks