how to link to date table with two data sources?

[naifAhmedB]

hi 

i have created a date table using calander and in want to sync it with the data sources table coulume "date"

I have two sources hourly and daily, how do i link them in the main date table?

[v-yingjl]

Hi @naifAhmedB ,

You can create relationships between these tables based on the date field to use it.

Please refer:

Create and manage relationships in Power BI Desktop 

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

[amitchandak]

@naifAhmedB , if both are part of the same pbix. You can join the date with dates table date

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.