Forum Discussion
Date Relationships - Multiple Tables, Multiple dates.
Hi All, I've been self thought in PowerBi for a few months now and have been starting to get to grips with the relationship model. However, I am struggling with the date table. As you can see fro...
Anonymous - You can have multiple active relationships for a date table to multiple other tables as long as you don't form 2 distinct pathways between any two tables. The minute you do that, one of the relationships becomes inactive.
Fantasic, that brings a lot of clarity to it for me around the date relationship. On the topic of model two, given that we have multiple tables that could be viewed as fact tables, is it ok to relate these considering that they are coming from Connectwise Data Warehouse.
Hi Anonymous ,
Yes,you can ,check the reference below:
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!