"Circular Dependency error"

[MIbrahim-power]

Dear experts,

Kindly find the attached error for your support. I didn't make any changes in my power bi files or updates and i suddenly faced this error message. What is your advice regarding this issue. i tried to check online for solution but i can't reach a clear solution to apply.

[danextian · Accepted solution]

Hi @MIbrahim-power 

There is a bug in the Nov release related to CALENDARAUTO.  That said, I would avoid  using this function and instead create a calendar in M or specify the start and end dates using CALENDAR()

[Anonymous · Accepted solution]

Hi @MIbrahim-power 

This issue has been confirmed as a known issue internally. You can try changing the CalendarAuto to Calendar function. Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MIbrahim-power]

Thanks for your reply, but i still cannot recognize the solution. The master date table is created by autocalender expression. This master date table is connected to other many table to combine date for all linked table. This relation was working properly without any problems fronm start of the year 2024 till end of october but from few days, this error appeared. Can anyone advise me to capture and resolve this issue?

[danextian · Accepted solution]

Hi @MIbrahim-power 

There is a bug in the Nov release related to CALENDARAUTO.  That said, I would avoid  using this function and instead create a calendar in M or specify the start and end dates using CALENDAR()

[tharunkumarRTK]

@MIbrahim-power 

Is [Master Date] a calculated column? 

if yes, have you used any other calculated column in [Master Date] column logic?

Since it is a date column it has created a local date table, see if disabling auto time intelligence solves the issue.

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!