Forum Discussion
Multiple active relationship workaround
In that case, I would use PowerQuery to 1. duplicate the vendor table, and 2. reduce the vendor table down to a single vendor id so that it could be used as a lookup table. Then I would simply use the original vendor table as another fact table and bridge it to the vendor id table and the date table. Bridge the Fact table to the date table and to the vendor id table. Make sure you populate the rows using the lookup table data and the values from the fact tables.
I've rearranged ym Data Model in the manner that you suggest however now I can't get any relationships to work. For example when I list the Lookup table ID and then try and bring in any columns from either table it simply lists every row with the same value.
Think my brain is fried for tonight so will have to try tomorro! Thanks.
Can you post a sample of your data here?