Forum Discussion
Advocate ICan't connect 3 table
Hi abdo132 ,
Just wanted to check if you got a chance to review the suggestions and whether that hepled you resolve your query. If you are still facing any issues, kindly share the sample file /sample data so that we can help you better.
Please exclude sensitive information from the data.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank You!
Super UserThis usually happens because you’re trying to force a fact-to-fact relationship, which Power BI doesn’t handle well.
The clean solution is to use the Calendar table as the single bridge:
Make sure your Sales (daily) table is related to Calendar by Date.
For the last year weekly table, don’t try to relate it directly to Sales. Instead, add a Week key (Year-Week) to both the weekly table and the Calendar table, then relate Weekly → Calendar on that key.
From there, all filtering flows through the Calendar, not between fact tables.
If the grains don’t match (daily vs weekly), keep them separate and handle comparisons in measures (e.g. TREATAS or DATEADD logic), not with physical relationships.