Forum Discussion
Circular Dependency Error but no dependency
this table definition looks benign. Have you marked it as a Date table?
Anyway, since dates are immutable it is always better to use a calendar table based on a precomputed source (like an Excel file on a sharepoint)
Hi brennahurley,
Just checking in to see if the suggestions shared by lbendlin and Deku helped in resolving the issue with calculating the end date of a unit’s status using DAX. As you encountered a circular dependency error, this usually occurs when a calculated column attempts to reference values that are also being calculated row by row within the same column.
If any of the responses by community members addressed your concern, please consider marking perticular response as the Accepted Solution. Feel free to reach out if you need further assistance or clarification.
Best regards,
Prasanna Kumar
Don't use CALENDARAUTO. Use an external reference table for your calendar table.
Where did I use CALANDARAUTO? I don't understand what you mean by using an external reference table for my calendar table. I have [Start Date] connected to a date table that is calculated as follows:
this table definition looks benign. Have you marked it as a Date table?
Anyway, since dates are immutable it is always better to use a calendar table based on a precomputed source (like an Excel file on a sharepoint)