Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm attempting to configure my data model, but have a question as to 'best practice' for this type of situation...
I have a table that contains appointments. The appointments have two date properties of intrest:
I have a typical DateKey table in my model, but I'm a bit confused about how to setup the relationship in the model. Do I:
Solved! Go to Solution.
Hi @pe2950,
your scenario is known as Role Playing Dimensions. You can create an active relationship between the Date dimension and the column from the fact table which you're more likely to use and an inactive relationship between the Date dimension and the other column in the fact table. When you want to browse your model by the date of the inactive relationship use the USERELATIONSHIP function to activate it in your measure
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @pe2950,
your scenario is known as Role Playing Dimensions. You can create an active relationship between the Date dimension and the column from the fact table which you're more likely to use and an inactive relationship between the Date dimension and the other column in the fact table. When you want to browse your model by the date of the inactive relationship use the USERELATIONSHIP function to activate it in your measure
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |