Forum Discussion
Date questions
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
Hello Anonymous ,
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
Hi Anonymous
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Idrissshatila
Super User
Hello Anonymous ,
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
Hi Anonymous
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.