The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
256 | |
120 | |
112 | |
83 | |
71 |