Why am I getting a circular dependency error?

Hi Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create a column.

age sort11 =
SWITCH (
    TRUE (),
    Sheet2[Age undelivered Bucket] = "<30 Days", 1,
    Sheet2[Age undelivered Bucket] = "30-60 Days", 2,
    Sheet2[Age undelivered Bucket] = "60-90 Days", 3,
    Sheet2[Age undelivered Bucket] = "3-6 Months", 4,
    Sheet2[Age undelivered Bucket] = "6-9 Months", 5,
    Sheet2[Age undelivered Bucket] = "9-12 Months", 6,
    Sheet2[Age undelivered Bucket] = "1 Year +", 7
)

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

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