Forum Discussion

Crazket's avatar
Crazket
New Member
1 year ago
Solved

Circular dependency error when using CALENDAR in Power BI Desktop (works in web version)

I am facing an issue with a DAX formula: CALENDAR in Power BI Desktop, but this error does not occur when working in the web version.   I haven't opened the file in a while, but now I need to edit ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Don't use Auto Date/Time, don't use CALENDARAUTO

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Crazket ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

 

Otherwise, could you please provide some raw data in your tables(exclude sensitive data) with Text format, the formula of measure/calculated column and visual Fields settings etc.? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

In addition, you can refer the following links to try to resolve it.

Understanding circular dependencies in DAX - SQLBI

Avoiding circular dependency errors in DAX - SQLBI

Best Regards