Forum Discussion
Anonymous
6 years agoNot applicable
Dynamically calculate sales amount based on the user input order qty
Hi All -
In the below table, if there is a change in the Order Qty as 30 for Catalog Price 110.the sales amount should change dynamically. Is it possible to do it in powerbi?
Please share your thoughts.
| Catalogue Price | Order Qty | Sales Amount |
| 110 | 5 | 550 |
| 125 | 10 | 1250 |
| 110 | 2 | 220 |
| 110 | 3 | 330 |
| 110 | 5 | 550 |
| 125 | 2 | 250 |
| 110 | 4 | 440 |
1 Reply
- amitchandak
Super User
Anonymous , I think you need to use what-if