Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have two tables that are linked to eachother by ID, they both have dates that are not 100% linked (some days missing for each month) which in result makes data not show up correctly when using date filter from either table1 or table2.
example of dates:
(In this image, there are no similarity between them, but there are dates that can be found in table1 and table2)
How would you resolve this the easiest to get data from table1 and table2 without having two date filters?
thanks
Solved! Go to Solution.
Hello @al427 ,
create a dim date table that has all dates and link it to both tables then you can use it as a filter.
https://youtu.be/-jRNjXyyWI4?si=OuqzDgXaX6JOZsHB
Proud to be a Super User! | |
Hi @al427
Thanks for the reply from @Idrissshatila , please allow me to provide another insight:
I added an ID column to the data you gave and created the relationship.
Table1:
Table2:
Two approaches come to mind for your reference
The first approach:
1. Merge two tables together in Power Query
2. Expand column
3. Close & Apply
Result:
The second approach:
If you could use the ID column as a slicer, you could do this.
If this sample data is structurally different from the one you are using, please do not hesitate to mention it and I will modify it.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @al427
Thanks for the reply from @Idrissshatila , please allow me to provide another insight:
I added an ID column to the data you gave and created the relationship.
Table1:
Table2:
Two approaches come to mind for your reference
The first approach:
1. Merge two tables together in Power Query
2. Expand column
3. Close & Apply
Result:
The second approach:
If you could use the ID column as a slicer, you could do this.
If this sample data is structurally different from the one you are using, please do not hesitate to mention it and I will modify it.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @al427 ,
create a dim date table that has all dates and link it to both tables then you can use it as a filter.
https://youtu.be/-jRNjXyyWI4?si=OuqzDgXaX6JOZsHB
Proud to be a Super User! | |
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |