Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone.
Initially after encountering this error, I figured out that using calculated was the main source of this problem, I took another route and then used 'IF' to get the values.
But when I am using the two calculated columns to create another column, I encountered this error.
Following are the calculated columns:-
1. revenue gross = IF(order_items[is_item_gross], [revenue all], 0) // calculated column
2. revenue net = IF(order_items[is_item_net], order_items[revenue gross], 0) // calculated column
3. rev progress = IF(order_items[is_item_in_progress], order_items[revenue net],0) // calculated column
4. rev inprogress shipped = [% shipped2] * order_items[revenue in progress] //calculated column
5. orders sold = IF(order_items[is_item_sold],order_items[order gross],0) // calculated column
6. order gross = IF(AND(order_items[orders all], order_items[is_item_gross]),1,0) // calculated column
7.
% shipped2 =
var progress_order = CALCULATE([orders sold], order_items[is_item_in_progress], order_items[delivery_status]="Shipped", order_items[status]="Shipped")/*IF(AND(VALUES(order_items[is_item_in_progress]), AND(VALUES(order_items[is_item_gross]), VALUES(order_items[delivery_status])="Shipped")), [orders gross],0)*/
var in_progress_order = CALCULATE([orders sold], order_items[is_item_in_progress])/*IF(VALUES(order_items[is_item_in_progress]), [orders gross],0)*/
return (DIVIDE(progress_order,in_progress_order))// measure
8. rev progress not shipped = VALUE(order_items[rev progress]) - VALUE(order_items[rev inprogress shipped])// calculated column and error "A circular dependency was detected: order_items[rev inprogress shipped], order_items[rev progress not shipped], order_items[rev inprogress shipped]" // calculated column
Kindly guide.
Regards
aJ2
Solved! Go to Solution.
Thanks for the reference.
I altered my approach. To calculate the column 'rev progress not shipped', I created local variables in the calculated column and then used the local variables in the calculation.
@aJ2,
You may take a look at the following articles.
Thanks for the reference.
I altered my approach. To calculate the column 'rev progress not shipped', I created local variables in the calculated column and then used the local variables in the calculation.
User | Count |
---|---|
106 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |