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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors