Forum Discussion
Circular Error Different Tables
it's because calendarauto() autogenerate calendar table based on the dates from model. it means in your case calendarauto() implicitly depends on Table[date]
https://learn.microsoft.com/en-us/dax/calendarauto-function-dax
you should define calendar table manually, for instance with CALENDAR() function
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!
Hello Syndicate_Admin ,
can you provide a link of your pbix file so we could check what's happening.
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
maybe because other tables have no relationships with this calendarauto()? can you show the model diagram at least?
