Forum Discussion
Helper IIhow to link to date table with two data sources?
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?
2 Replies
- amitchandak
Super User
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.
v-yingjlCommunity Support
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.
