Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Syndicate_Admin
Administrator
Administrator

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 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?

5 REPLIES 5
az38
Community Champion
Community Champion

Hi @Syndicate_Admin 

 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

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!

@Syndicate_Admin 

maybe because other tables have no relationships with this calendarauto()? can you show the model diagram at least?


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Hello @Syndicate_Admin ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

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


Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.