I have a data modeling question as it relates to multiple dates. I thought Power BI can’t recognize two active relationships in a Date Tbl but for some reason in my model the relationship is active for both tables. I have an active relationship to Contact Create Date in the Prospects Tbl and an active relationship to RFP Receive Date in the Opportunities Tbl.
From a performance standpoint, will there be an issue? Should I make one of them inactive?
Thanks for your feedback. Just trying to understand better.