Forum Discussion
Why am I getting a circular dependency error?
I am updating a report I created a long time ago to be more efficient. I am trying to swap out a long nested IF statement for a SWITCH statement in a table, but I keep running into an error. I ha...
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.
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.