Forum Discussion
Circular Unit
Hi I am a PBI user and I have a problem.
from now on I appreciate the help
when I relate the calendar table to the purchase order table, it gives me the following error
if I do it with the invoices table there are no problems.
I don't understand what the error may be
3 Replies
Syndicate_Admin , You have a few bi directional joins, those are creating a loop. Make them single directional and check
Thank you very much for your reply.
to review this issue I only have three tables, calendar, invoices and OC.
When I try to relate the calendar table to the OC table, it generates the problem for me. The truth is that I do not understand why with the invoices table if it operates, but not with that of OC.
If I make the relationship OC to calendar I if I let it do. But it doesn't operate properly. If I modify this relationship manually, it also does not operate correctly.
if I delete all the relationships that are there and try to create only the calendar one with oc I still get the error
If I leave only the calendar table and OC the error also occurs
I would be very grateful for your help
I've already found the problem. It was the form of the date column of the OC table
