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:
Thank you,
Denisse
Solved! Go to Solution.
@ruesaint_denis Create the relationship between the Date and Orders table and use USERELATIONSHIP
@ruesaint_denis Create the relationship between the Date and Orders table and use USERELATIONSHIP
@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.
User | Count |
---|---|
110 | |
60 | |
58 | |
38 | |
37 |
User | Count |
---|---|
117 | |
66 | |
65 | |
64 | |
48 |