Forum Discussion
Advocate IMultiple relationships with Date report filter
Hi,
I have a Fact Table that contain two different Date (exple : Creation and Update) and i have Date Dimension, beside all this i have a Date Report filter that i did from my Date dimension and i want that this filter works on all my dates including the two date on my fact Table, since the multi relationships doesn't work on Power BI i really don't know how to do this.
I have more than two different date, that was just an exemple, actually i want just to make sure that everyone is looking at the same range within my fact table.
I hope i was clear, please let me know if i wasn't that i explain more.
Its is a very urgent subject i hope you could help me
Thank you
9 Replies
rajulshahResident Rockstar
You can make relationship on these two dates.One active and another one inactive.
You can create active relationship on the one that is used most while calculating a measure , and can use USERELATIONSHIP whenever you want to use other date.
Hope this helps,
Thanks!
Hind26Thank you for your answer, i have already tried this solution, but i figured out that using the function UseRelationship on the inactive relationship inactivate the other one, it doesn't work in addition on my existing active relationship.
- rajulshah
Sorry , but you cannot have more than one relationship between two tables.
I have a similar use case where I have effective dates and expiration dates. I use 3 different date tables, one for Effective (active), one for expiration date (Inactive) and one main date table for filtering that has an active relationship to both of the other date tables. I specify which relationship I want to use regarding the fact table to the sub date tables in each measure. Then I use the main date table for all filters. This filters each of the sub date tables appropriately.
I see that this post is old, but hope it helps someone.
