Manual input with resulting table

[snafziger]

Hello all,

I am trying to create a report that lists the following in a table (visual), for example:

- Part

- List Price

- Discount Price

I would like for "Discount Price" column to be a calculated column based on manual input; that is, I would like for the end user to be able to manually input a discount (for example, "20%") and see the results in the table (List price = regular price, Discount price = 20% of regular price).

Is this possible to do (manual input with resulting table)?

[Pragati11 · Accepted solution]

Hi @snafziger ,

You can try using What-If Parmeters to achieve this. Refer the following:

https://www.absentdata.com/power-bi/parameter-power-bi/

https://radacad.com/power-bi-what-if-parameters

Thanks,

Pragati

[snafziger]

Thank you I appreciate your help