Forum Discussion

naifAhmedB's avatar
naifAhmedB
Icon for Helper II rankHelper II
5 years ago

how 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? ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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.