How to connecte a date table to a table with many date columns?

[Yacine_VC]

Hello everyone,

I'm facing very often an issue with my Power BI models : it's when I have to connect a date column from a table to a time table.
Sometimes I have two date columns in the same table (date beginning and date end for exemple), but I connect both to the time table, which I need to filter by year.

On model view, one connection is active and the other(s) must be inactive. Same thing if I try to create a new table for each date column, each one connected to the fact table : if one is already connected to the time table, I can't add more active connection because "there's ammbiguous accesses" between the table. I can only create inactive connections.

What would be the good practice here ? Should I use inactive connections and connect them momentarily during the calculation of the measures ?

[Greg_Deckler · Accepted solution]

@Yacine_VC The two common approaches are to use USERELATIONSHIP in measures or to use multiple date tables. Here's a video I made on various ways to solve problems like these:

[Yacine_VC]

Hello Greg_Deckler,

Thanks a lot, that's very helpful.