creating a dynamic product price calculator based on raw materials cost dataset

[Vandergledison]

Dear all,

i have a dataset containing raw materials A, B C, D and its respective costs per Kg, 1,2 3,4.

i would like to create a simple calculator for a product X which should be obtained by adding (scroll down menu?) the raw materials and manually inputing the amount of kg of each raw material. 

in the end , it should give me a Product X cost .

im more familiar with power Bi, and i know its a bit tricky to work with input there, so i thought that in Excel might be possible/easier,

any help its apreciated,

thanks in advance

[lbendlin]

 and manually inputing the amount of kg of each raw material

That's not something you can do in Power BI.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41