cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snafziger
New Member

Manual input with resulting table

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)?

1 ACCEPTED SOLUTION
Pragati11
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

2 REPLIES 2
Pragati11
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Thank you I appreciate your help

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.