Best way to connect 20 plus tables with dim date table

[Anonymous]

Hi,

I have 20 plus tables witch has different starting dates, I gave relation ship by using a new table with calender function. But want to know what is the best way to connect number of tables with a single dim table.

[v-yalanwu-msft]

Hi @Anonymous ;

You can create a structure similar to the star model, with the date table as a unique value, linking to more than 20 other tables with dates,

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , If these tables contain the same data with different duration then merge them. Else just join them with dimension one by one