Error Date table relationship with other date table

[proavinash]

[v-vpabbu]

Hi @proavinash,

As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @proavinash,

As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @proavinash,

As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[uzuntasgokberk · Accepted solution]

Hello @proavinash ,

In the SalesDump table, I noticed it has many-to-one relationships with other tables that are not visible. My assumption is that you’re using something in the visual layer that indirectly connects to the DimDate table. If you’ve created multiple active relationships between the same tables, that could be causing the confusion. While connecting both directions might seem to solve the problem temporarily, it is not considered best practice. Instead, I recommend establishing one-way relationships from the fact tables (e.g., Deliver) to the DimDate table.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |