Forum Discussion
Helper ISconto a cascata
Quando vi trovate nella situazione di avere un prezzo lordo più una serie di sconti, qual'è secondo voi il miglior modo di calcolarlo? Considerando che magari in alcuni casi gli sconti non ci sono o ce ne sono solo un paio
Esempio € 100 - 50% - 30% -20% - 5%
Grazie
Hi, Supermat
You could create a calcualted column like this:
Column = [Gross_Price]*(1-[Discount_1]/100)*(1-[Discount_2]/100)*(1-[Discount_3]/100)Result:
If this is not the result you want, please provide examples of what you want as a result, it makes it easier to give you a solution.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- v-angzheng-msft
Community Support
Hi, Supermat
You could create a calcualted column like this:
Column = [Gross_Price]*(1-[Discount_1]/100)*(1-[Discount_2]/100)*(1-[Discount_3]/100)Result:
If this is not the result you want, please provide examples of what you want as a result, it makes it easier to give you a solution.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SupermatThx for your support.
- amitchandak
Super User
Supermat ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- Supermat
amitchandak I'm on query editor and i want to add a net price column. This is my table.
Gross_Price Discount_1 Discount_2 Discount_2 100 50 30 0 200 50 20 5 150 40 0 0 50 0 0 0
- Supermat
UP!
