The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I'm trying to write some sort of formula to evaluate the shipped Qty vs the Order Qty by SO # and maintain the item levle details like the example below
SO # | ItemNumber | LineCount | OrderQty | ShipQty | In-Full? |
SO-1 | 1 | 1 | 100 | 100 | 1 |
SO-1 | 2 | 1 | 200 | 200 | 1 |
SO-1 | 3 | 1 | 150 | 0 | |
SO-1 | 4 | 1 | 75 | 75 | 1 |
SO-1 | 5 | 1 | 22 | 22 | 1 |
SO-1 | 6 | 1 | 65 | 0 | |
SO-1 | 7 | 1 | 70 | 70 | 1 |
SO-1 | 8 | 1 | 6 | 6 | 1 |
SO-1 | 9 | 1 | 12 | 12 | 1 |
Total | 9 | 700 | 485 | 0 |
Thanks!
Solved! Go to Solution.
hello can you please calirify more?
you want to compare countorder with qtyship ? and if = then 1 if not then 0?
Hi - sorry, the column headers got weird when I posted it... I'm looking to compare ShipQty and OrderQty.
I'm trying to create a measure that will show a 1 if either the order line or order total is shipped in full
something like this ?
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
21 | |
20 | |
11 | |
10 | |
7 |