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 User
Use a single Date table and relate both files to it – don’t join the fact tables.
DimDate =
ADDCOLUMNS (
CALENDAR ( MIN ( Sales[Date] ), MAX ( Sales[Date] ) ),
"Year", YEAR ( [Date] ),
"WeekNum", WEEKNUM ( [Date], 2 )
)
Add same Year + WeekNum (or a YearWeek key) to your LY weekly file.
Relationships:
DimDate[Date] → Sales[Date]
DimDate[YearWeek] → LY_Weekly[YearWeek]
Use DimDate in slicers. Both daily Sales and weekly LY data will filter correctly through the shared date table.
If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
Advocate Ilooks nice idea I tried it but I don't know why the filters are not working