Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 PriceOrder QtySales Amount
1105550
125101250
1102220
1103330
1105550
1252250
1104440