Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need help with Converting my inventory from pcs to Sales unit of measure Which can be displays, PCS, mastercase.
How Can i link these 2 table or add new cloumn which can convert all my items from pcs to sales unit of measure. So, I can see how many displays or master I have to sell.
Solved! Go to Solution.
Hi @Atinder
You can merge using the the columns NO=Item NO and Sales Unit of Measure = CODE
Hope this helps
Hi @Atinder
You can merge using the the columns NO=Item NO and Sales Unit of Measure = CODE
Hope this helps
Hi @mussaenda
I tried but it is not working. I need like conversation pcs to Displays .
Hi @Atinder ,
if you will provide a sample data with your expected output,
the community can help you better.
Thank you!
I figured it out thank you
Hi @Atinder ,
Could you please share your solution and mark it as solution? That will help other people with the same problem to find the solution quickly.
Best Regards,
Winniz
Hi, @Atinder
Please look at the example below. I need more information about first table, is No column unique (no duplicates)?
Proud to be a Super User!
Hello @ALLUREAN,
in 1st Table is No. column is unique there is no duplicate in that but in second table Item no is repearting becasue of Unit of measure. Our base unit is pcs but we sell some SKU'S by Displays (which can be 12, 15,18,20 pcs) or mastercase qty. I want convert my inventory from Pcs to sales unit of measure whih is last column in 1st table and Qty per Sales unit is in 2nd table.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |