Forum Discussion
Solved
Dealing with possible ambiguous relationships
Hello, people! I realize Power BI normally doesn't support multiple relationship paths between 2 tables, since it would introduce ambiguity when propagating the filters, which does make sense. Wi...
Could you add the Department to the expense lines directly and assign it based on the expense date?
Yes, I could theoretically use PowerQuery to generate a Department column in the ExpenseLines table and assign it as you suggested.
I had never thought about considering Departments and CostCenters as 2 independent dimensions in the model, but that would probably work. I'll give it a try!
Thanks for the help!