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 a...
Need Help
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