Forum Discussion

jbotero's avatar
jbotero
Frequent Visitor
8 years ago

Find inventory by goals

Hello Power BI Community!

 

I have searched for help in here and other sources as Stack Overflow and YouTube with no luck, so I want to post my question here looking for help from you.

 

I have an "Available Inventory" data source. I have also some sales goals and what I wish is to look up into the available inventory table until I reach the goal. I have done simplified example in Excel just to illustrate what I want. 

 

 

In my example, shirts goal was $120 and it took up to 4 products to reach that goal. Therefore, I would want a visual that shows me the necessary inventory to reach the goal. Exactly the same with the rest of categories.

 

Thanks for your kind help. I hope I have been clear enough with my requirement.

 

Kind regards,

Juan

Need Help

4 Replies

  • Hasan's avatar
    Hasan
    Resolver I
    8 years ago

    HI,

    Can you also share your sales table so i can take a look at the possible solution?

     

    Hasan

    • jbotero's avatar
      jbotero
      Frequent Visitor
      8 years ago

      Hello Hasan.

       

      This is the actual goals table for June:

       

      ProductJune goals
      Accessories $      321.65
      Shorts $      343.08
      Wallets $        24.50
      Purses $      180.93
      Sweaters $   1,667.64
      Shirts $   2,064.08
      T-shirts $   6,230.11
      Belts $        81.85
      Parfums $        50.57
      Sunglasses $      240.43
      Caps $        58.36
      Jeans $ 14,058.63
      Socks $        79.35
      Pants $      764.28
      Watches $   2,145.92
      Swimwear $      123.03
      Underwear $      304.40
      Temporary $      623.24
      Shoes $ 15,503.88

       

      Thanks for your help!

       

      Juan

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi jbotero,

     

    Please clarify more details about your expected requirement.

     

    Regards,

    Jimmy Tao

    • jbotero's avatar
      jbotero
      Frequent Visitor
      8 years ago

      Hello Jimmy.

       

      What I expect is through DAX to state a formula which makes a query to the database of products. Then, through a visual, see the products that satisfy the conditions.

       

      For example, my database has shirts from 1 to 6, with a total value of $255. The condition will be the goal, $120. Therefore, I need something that tells Power BI to go and find the products until they reach the value of $120 (in this example, shirts from 1 to 4). Finally, I want to use a visual that shows me which are those products.

       

      This is what I expect, however, if you have another solution I will appreciate it.

       

      Thanks a lot.

      Juan