Forum Discussion
Post PatronDate Table - how many relationships?
Hi all
can the Date Table be related to more than 1 fact table ?
I seem to remember it can only have 1 relationship.
You can relate to any number of tables. Just make sure there is no loops
In one table you can have one active join.
Refer :
One table more than one join : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://www.dropbox.com/s/excoqikgpyz5zvk/Current_employee.pbix?dl=0
Two or more table, with each table there is an active join
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
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 :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
1 Reply
- amitchandak
Super User
You can relate to any number of tables. Just make sure there is no loops
In one table you can have one active join.
Refer :
One table more than one join : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://www.dropbox.com/s/excoqikgpyz5zvk/Current_employee.pbix?dl=0
Two or more table, with each table there is an active join
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
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 :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/