Compute result based on user entered quantity

[dreww12345]

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!

[dreww12345]

That works. Thank you for the help!

[samdthompson · Accepted solution]

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.