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!
Advocate Iwell they don't have the same format, also the last year data has only weeks data and daily data so it's hard to combine them , If you have any other way on the combine them show me please
Super UserCreate a virtual date column for the last year's data, for example "first day of the week". Then you can append the tables and link to the calendar table via a common key.
- danextian
For simplicity's sake and if combining the data in Power Query isn't computationally expensive, I would follow lbendlin 's suggestion especially if there are other dimension that the two fact table shares. You need to make sure that prior to appending that the common dimensions between the two have the same names so if you create the start of week, rename that to Date if the other table uses Date.
If this isn't feasible, you can virtually establish the relationship between last year's data and the Dates table using a measure. For example:
CALCULATE ( SUM ( LastYear[value] ), TREATAS ( VALUES ( dimDate[week column] ), LastYear[week column] ) ) + SUM ( CurrentYear[value] )This should display values from both tables in a single visual, using the columns from the Dates table. Naturally, last year’s data cannot be shown at daily granularity since it is only available at the weekly level.
