Forum Discussion
Multiple active relationship workaround
Is there a work around for Power BI not support multiple active relationships? I have a situation where my Fact Table is related to another table in a one-to-many relationship. The fact table bein...
In an SSAS tabular on-line training course, I have found the following statement by Peter Myers (MVP) from Bitwise Solutions (one of the trainers on the course):
It is generally a good practice to only define active relationships. Instead of having active and inactive relationships consider creating duplicate tables. For example in an order table where you have order date and a ship date columns, create a Order Date table and a Ship Date Table.
I would expect this best practice advice would also apply to the power bi scenario?