Forum Discussion

shady_hamilton's avatar
shady_hamilton
Regular Visitor
7 years ago

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...
Need Help
shady_hamilton's avatar
shady_hamilton
Regular Visitor
7 years ago
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
Omega's avatar
Omega
Impactful Individual
7 years ago

I believe you are trying to create the below tables. If so, how much quantity do you have in the purchase columns? 

 

  • shady_hamilton's avatar
    shady_hamilton
    Regular Visitor
    7 years ago

    Hi Khader,

     

    no, i have two tables, the first one will log the purchases per day/time.... the other one will log the stock we purchase, we top up the stock every now and then, so no specific amount or intervals.  these are two seperate tables

     

    i want to know at a certain time how much stock i still have from one item by calculating the sum of the purchases of one item and deducting it from the total of the stock for that item. 

     

    showing each item in one box in Power BI is easy, my issue is that i have a lot of items, so i want to have a dropdown filter, where i select the item and it will show me the remaining stock for that item.

    • shady_hamilton's avatar
      shady_hamilton
      Regular Visitor
      7 years ago

      Any help please?

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi shady_hamilton,

         

        Do you want to create a dropdown list with values of Toy, pencil, book and pen?

         

         

        If it is convenient, please share your desired output so that we could help further on it.

         

        Best  Regards,

        Cherry