Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Circular Error Different Tables

I have two tables that I want to relate. A dimcalendar that is generated with Calendarauto(). And the other table contains two columns, one with dates and the other with sales values. There are no ca...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hi, I understand what you mean but why does it work then with all the other tables? This is the only one that has given me problems. All the others have a [Date] column and there was no problem relating it to dimCalendar[Date].

Thanks a lot!

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello Syndicate_Admin ,

 

can you provide a link of your pbix file so we could check what's happening.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Reviewing the table that gave me an error in the relationship with calendarauto() I realized that it had no duplicates, being a table that came SUMMARIZE by date, it did not have any duplicate value. When I made the relationship from one to many, I had a circular error. I don't understand, I know it's wrong because there are no duplicates and it doesn't make sense from one to many but I don't understand why the error is circular, hence I won't find the error