Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 calculated columns or measurements. When making a relationship between dimcalendar[Date] and Table[date] I get a circular error. How can it be if the tables are unrelated to each other?
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!
maybe because other tables have no relationships with this calendarauto()? can you show the model diagram at least?
Hello @Syndicate_Admin ,
can you provide a link of your pbix file so we could check what's happening.
Proud to be a Super User! | |
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |