Circular dependancy error

Hi, baneworth 

I have tested your DAX formula using the created column you provided and based on the fact that one serial number corresponds to multiple dates as you mentioned. The test resulted in no circular dependencies and got the target column you wanted. Here's a screenshot of my test:

DAX formula:

QCBS Done = CALCULATE(MIN(Fact_QCBS[created]),ALLEXCEPT(Fact_QCBS,Fact_QCBS[Serial number]))

The results are as follows:

There are many reasons why circular dependencies arise, and here are some of the possible reasons I've compiled:

1. The value of one column depends on the value of another column, which in turn depends on the value of the first column. In this case, the DAX engine cannot determine which column should be calculated first, and therefore reports an error.
2. Table A depends on Table B, which in turn depends on Table A. Then there is a circular dependency.
3. If other columns in your table depend on the created column or the serial number column, a circular dependency occurs.

Can you provide me with a sample PBIX where this problem occurs? I'll try to help you as soon as I can.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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