Forum Discussion

dreww12345's avatar
dreww12345
Helper I
5 years ago
Solved

Compute result based on user entered quantity

Hi

 

I am working on a dashboard that will show my employees the amount of raw materials required for a production item.

 

For example, 

 

1 unit of production item C-1234 may require 3 units of C-2233 and 4 units of C-2244 to produce.

 

I want the user to be able to enter an item and a quantity and have the report return the number of units required based on the entered quantity

 

So to continue with the above example if a user enters

 

Item: C-1234 Quantity: 3

 

I would like the report to return: C-2233 9 units, C-2244 12 units

 

Can this be achieved using PBI? Any ideas or suggestions would be greatly appreciated

 

Thank you!

 

 

  • Hello, yes this is possible using parameters. Go to the modelling tab and the parameters button. This is a GUI version of making a table with GENERATESERIES(). You can then use the list of numbers as multipliers for your scenario in any calculation.

     

     

2 Replies

  • samdthompson's avatar
    samdthompson
    Memorable Member

    Hello, yes this is possible using parameters. Go to the modelling tab and the parameters button. This is a GUI version of making a table with GENERATESERIES(). You can then use the list of numbers as multipliers for your scenario in any calculation.