cannot create a direct active relationship between two tables

[Lolo_2023]

Hi experts,

I have two tables, the column “Department “it has a fixed values in two tables and the column “Values “

Has a different values, when I tried to represent the data of two tables based on date, the data don’t shows and when I do the relationship between table 1 and table 2 this message appear “can't create a direct active relationship between two table, To make a relationship active, deactivate or delete one of the relationships between calendar table and table 2"

Because I have two relationships :

1 . Between table 1 and calendar table

1. Between table 2 and calendar table

 

Can anyone help me,how to fix it .

[Gabry · Accepted solution]

Hello @Lolo_2023 

Thank you for explaining your model. Based on your description, I would recommend adding a Department dimension table. You can then link this Department table to both Table 1 and Table 2, instead of directly connecting Table 1 to Table 2.

To create the Department table, you can simply use the `DISTINCT` function on the department column.

[Lolo_2023]

Thank you, it works