topic Re: Error Date table relationship with other date table in DAX Commands and Tips

Error Date table relationship with other date table

proavinash — Sat, 31 May 2025 09:59:16 GMT

Re: Error Date table relationship with other date table

uzuntasgokberk — Mon, 14 Jul 2025 12:03:52 GMT

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.

Re: Error Date table relationship with other date table

Anonymous — Tue, 03 Jun 2025 11:57:08 GMT

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

Re: Error Date table relationship with other date table

Anonymous — Fri, 06 Jun 2025 12:39:47 GMT

Hi @proavinash,

Regards,
Vinay Pabbu

Re: Error Date table relationship with other date table

Anonymous — Mon, 09 Jun 2025 12:01:54 GMT

Hi @proavinash,

Regards,
Vinay Pabbu