Sure, here's an example. My fact is a snapshot fact - Balances, status changes, days past due, etc. There are some dates, like LastPaymentDate, LastPartialPaymentDate, StatmentDate, and the SnapshotDate. We limit the model to month-end snapshots up to the previous month, and daily for the current month. The Dimension has the static info about the account - the AccountNumber, OpenDate, CloseDate, ChargeOffDate, rates and terms, etc.
I have joins between Date dimension and the fact with the SnapshotDate being the active join, so you can see daily balance, stauts, delinquency etc. I have measures with =USERELATIONSHIP() for some of the other dates.
The business has a need to know how many accounts opened, closed, charged off on a day, so I want to join the date dimension to those dates too, but I am prevented from doing so by the existing join. "There are ambiguous paths between LoanFact and Date: LoanFact->Loan->Date [This is the one I'm trying to add] and LoanFact->Date." [This is the existing join]
In the existing reporting, we use SSRS so the reports are static and there is no issue. But with PowerBI we want them to be able to make YOY or MOM comparisons by using the Date dimension at whatever granularity they want, and I have not found any best practices on how to resolve this. I am accessing my underlying star schema by views with some restrictions.
Thanks for thinking about it!