Date questions

[al427]

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

[Idrissshatila · Accepted 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

[v-xuxinyi-msft · Accepted solution]

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.

[Idrissshatila · Accepted 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