Date questions

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 Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.