Forum Discussion
Joining does not work properly
Hello,
I have 4 tables and I join them by product SKU, but when I try to create a table using Sale_AC and Inv to it does not work the way I want it. I want to see each place quantity, but it gives me total quantity for all location. I could not figure it out. Can anybody please tell me what’s wrong with it.
Thank you so much
16 Replies
Here is the link for sample pbix with dataset and join that I did
what result you are expecting? It is working as expected. it is showing Inv.Quantity for sky, you are showing line items from sales table and it is repeating inv. quantity, either you sum up your sales quantity (one row for each sku) and then it will show you correct result.
I don't see any issue, it is just how you are visualizing your data.
If you remove store name, all is fine.
Thank you for quick respond.
I want to see each store that particular SKU (I have a filter for SKU to see different product and I also have a store filter too.) Performance. I want to see how many quantities sold, sales (From Sales_Ac), any transfers, on order and Inv.Qunatity which means stock on hand for each store from Int table.
I have an internal tool to validate. Per this SKU (BPCBDP000176) We have total inventory of 79 (whole company). I am looking get something similar like this. Please see below table
Store Name Products Name SKU Sold Quantity Sales On Transfer On Order Inv.Quantity 203 Tyler Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 1 18.98 2 301 Evansville Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 1 18.98 10 314 Chattanooga Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 2 37.96 5 410 Bend Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 1 18.98 3 702 Athens Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 1 18.98 0 706 West Cobb - Marietta (WC) Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 1 18.98 1 708 Norcross Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 2 37.96 1 713 St. Simons Adopted Wrap iPhone 6/6s - OLIVE/GUNMETAL BPCBDP000176 1 18.98 8 --- so and so --- Total 79 I change all my feild to sum, but still no change. Any idea why is that. I thought something wrong with Join.
Thank you so much
