Forum Discussion
Joining does not work properly
why your inventory table will have duplicate records, seems like there is dataset challenge than powerbi. You can surely have another table to join these together which is easy to do but I would recommend look at your invt table and make sure that you expect duplicate rows in it.
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.