cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Dealing with Multiple Tables connecting to One Date Table

Hello Community, 

 

I have a question that I think many may have experience with. I have a Users table, and an Orders table. They both have important dates that I'd like to do time intelligence on. For my Users table, I have created a Date Table, and have both inactive and active relationships there, no problem. But what do I do about my Orders table? I create an Orders Date Table, but as you can imagine, it's very messy when I want to filter on a page. 

 

How can I have only 1 Date Table, and both my Users and Orders table refer to it?! 

 

Here is my model:

ruesaint_denis_0-1627936174960.png

 

Thank you, 

 

Denisse

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@ruesaint_denis Create the relationship between the Date and Orders table and use USERELATIONSHIP


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@ruesaint_denis Create the relationship between the Date and Orders table and use USERELATIONSHIP


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler it won't interfere with my model? I have a connection b/w Users and Orders, and Users connects to Date table. It's ok to also connect Orders to Date table?

@ruesaint_denis Sure, it will just be inactive is all. That's why you use USERELATIONSHIP to tell DAX which relationship to use.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors