Dates Table Relationship

Hi Anonymous 

Which fields do the "calendar" and "actual vs budget" tables connect?

It seems they have a "many to many" relationship.

To make the relationship work, it needs a "one to many" relationship.

 

For example, please take a look at my test.

I merge "actual" "and "budget" tables to get a new table "actual vs budget",

Then create another table "country" based on the table "actual vs budget",

country = VALUES('actual vs budget'[country])

Assume "period" in the calendar table from your screenshot refer to four quarter one year (1,2,3,4),

 i can create a calendar table as my pbix shown,

then i create a new table based on this table

period yyyy table = VALUES('calendar'[period yyyy])

Finally, with correct relationships, i can filter "actual vs budget" based on country/date period.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.