Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear
How can we relate(or work) between Fact table that multiple date columns(ex: mr date, rfq date, bc date, tbe date, awr date, po date etc and more) and dates table(column date,month,qtr,year)
@Anonymous
You can create Active and InActive relationships between Dates and Fact tables then use USERELATIONSHIP function in your calculations:
https://www.youtube.com/watch?v=X9rkpt7-LNQ
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
First thanks for your reply,
we can do like that but i have more than 15 dates column in Fact table
Once we create relation between two tables more than 15, may be performance will be degrade
is there any better solution apart from creating more relationships ??
Waiting for community reply
@Anonymous
I am not sure if you are using all those dates columns in the fact table. When you have many relationships, they will not degrade unless they are used in your calculations. Wherever you need to activate the inactive relationship only, you can use it.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |