Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I need to calculate the ratio between the started quantity and the finished quantity for each order.
But just for finished orders.
So, I have an item master, the order table with the started quantity, and a second order table with the finished quantity.
In der second table you will find just orders, that a finished.
To calculate the ratio a simple DIVIDE will not work, right?
How can I exclude not finished orders from the calculation?
best regards
Hi @joshua1990
you can compute the ratio using divide, but how to exclude unfinished orders will depend on what your data looks like.
Cheers,
Sturla
If any of the answers you have received has helped you, please consider marking one of them as accepted solution. If not, please add more information to help the community help you
@joshua1990 , difficult without looking at data. You can have the common item, order, and date dimensions and analyze data based on that. You can have order status as a common dimension and filter the status too. or filter in the measure.
Can you share sample data and sample output in table format?
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
39 | |
20 | |
12 |