Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi @brennahurley,
As we haven’t received any further updates and there are no outstanding queries at the moment, we’ll go ahead and close this thread for now. If you have any additional questions in the future, please don’t hesitate to start a new thread we’re always here to help.
Warm regards,
Prasanna Kumar
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
Hi @brennahurley,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
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)
'DimStatusLog'[Full House Number] = fullHouseNumber
Is syntactic sugar for
Filter( all( 'DimStatusLog'[Full House Number] ), 'DimStatusLog'[Full House Number] = fullHouseNumber)
You can replace this with allnoblankrow to avoid consider the blank row consideration and therefore the circular reference
Filter( allnoblankrow( 'DimStatusLog'[Full House Number] ), 'DimStatusLog'[Full House Number] = fullHouseNumber)
You need to do the same with the date filter.
This article explains https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/#:~:text=If%20your%20code%....
I tried this with the following code and got a simmilar error to before:
With a pbix file hard to debug. I would suggest moving the calculated column to powerquery
User | Count |
---|---|
73 | |
72 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |