Circular Unit

[Syndicate_Admin]

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

[amitchandak]

@Syndicate_Admin , You have a few bi directional joins, those are creating a loop.  Make them single directional and check

[Syndicate_Admin]

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

[Syndicate_Admin]

I've already found the problem. It was the form of the date column of the OC table