Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using two lookup tables connected with the same fact table

Hi.   I have two lookup tables:   USER LOOKUP user_id 1 2 3   DATE LOOKUP date 1/1/2018 2/1/2018 3/1/2018   ..connected to a fact table (1-to-many cardinality ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    In my opinion,you'd better use user_id from the profile fact table in all your calculations since it's the one-side in the relationship.And since it has a connection with user lookup table,I believe it wont defeat the point of the table.

    Check the reference below:

    https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Anonymous ,

 

In my opinion,you'd better use user_id from the profile fact table in all your calculations since it's the one-side in the relationship.And since it has a connection with user lookup table,I believe it wont defeat the point of the table.

Check the reference below:

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!