Forum Discussion
Joining does not work properly
I do nto have a controll on their databases. I have a sql server analysis connection with them. Any idea How I create a sub table on using my inventory table. So I can join with other table and start working on my Week on Had report. I just want to get the store name, sku and how many transfer, on stock and on order for that store.
does the duplicate rows have same values?
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.