Forum Discussion

jPinhao's avatar
jPinhao
Advocate II
10 years ago

Cyclic relationship between tables

We have some fact tables (Database Opened / Database Available) in Power BI that reference columns in multiple common reference tables (All Databases / events):     (There's other fact/refer...
Need Help
Mi2n's avatar
Mi2n
Microsoft Employee
10 years ago

jPinhao... just wondering, why can't you combine the tables "Database Opened" and "Database Available" into a single table, and have a new field (say "Database availability") in the single table in order to distinguish between the two tables?

 

This will make the relationships simpler.