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 giv...
if that is the case, you can remove duplicate rows in query editory and that will give the unique value for each store and sku , and it will solve all the issues.
Thank you but in the worst case scenario (for data integrity), is there any way we can write a DAX or some other method for creating a subtable by store, and sku , for that sku how many on order, on transfer, and on stock without repeating, because I only test sample data. Its huge database (Inventory), so I am kind of worrying about it, so is there any way we can do it.
Thank you
just add a step to remove duplicate, we can always revert it and see if rest everything works.