Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to 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.
That works. Thank you for the help!
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
62 | |
54 | |
27 | |
16 | |
13 |