Forum Discussion
Filter on table and column
Hello, i have two tables, one that has the stock of each product and the second has a cloumn that has the names of the products purchased. each row of this column contain one product purchased, so if...
Can you please share a sample excel/PBIx file for the data set and the expected result? Thanks!
Hello Khader,
I am attaching the example. the first sheet has the column of the purchases per day and the other sheet has the purchased stock per date.
I want to know how much stock left from each product by selecting the name of the item from a drop down menu, when selected it will tell me how much purchased and how much stock left.
many thanks,
Hi shady_hamilton,
Maybe something mistake. We cannot see your sample data. Please upload your sample data and the desired output so that we could help further on it.
Best Regards,
Cherry
- sorry, not sure what happened, here is the sheets again, First Sheet (purchases) Date Purchases 01/01/2018 Toy 02/01/2018 Toy 03/01/2018 Pen 04/01/2018 Toy 05/01/2018 Book 06/01/2018 pencil 07/01/2018 Pen 08/01/2018 Toy 09/01/2018 pencil second sheet (Stock): Date Purchased Toy Pencil Book Pen 01/01/2018 10 5 6 15 02/01/2018 3 1 4 0 03/01/2018 4 0 4 0 04/01/2018 2 0 1 0
I believe you are trying to create the below tables. If so, how much quantity do you have in the purchase columns?
