Forum Discussion
Helper IUnable to create active relationship between multiple tables with date column
I have 3 different tables each of it having date column. Also i have created 4th customized date table which i am using for slicing all data based on "Date" column of this date table.
As per below currently there is active relation between "Rep Logins- All Divisions" & "Date" AND "Customer Logins" & "Date". If i am trying to create same relation with "Registrations Report" & "Date"..it is asking me to deactivate any one of the above relation first. This is observed with all combinations between these 4 tables. At a time it is taking only TWO active relations. I tried UseRelationship function as well but that's not helping here.
Is it possible to create relationship here? How?
Note: All below tables have same Data type of Date Column and Date format as well.
Hi rpagar ,
Have you checked amitchandak 's suggestion?
Based on my test,it is supported for 3 active relationships with 1 date table.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
6 Replies
- amitchandak
Super User
rpagar , Can you share a sample pbix after removing sensitive data.
rpagarSorry can't do that....that's why shared dummy names of tables with the proble statement...Do you need more explanation about the issue?
- amitchandak
rpagar , from the screenshot, the model is looking correct. Unless there other bidirectional joins that are not visible. Or table is created with a simple union of two tables, one of them already joined to this table.
v-kelly-msftCommunity Support
Hi rpagar ,
Have you checked amitchandak 's suggestion?
Based on my test,it is supported for 3 active relationships with 1 date table.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- rpagar
Yes i am able to create active relationship now. Thanks for help.
