Forum Discussion
Bonus Calculation
Hi All
I need some help with a Bonus calculation for my company
Our sales Team will get an extra bonus when they achieve a target, the bonus is progressive.
If they achieve lets say 1.2M to 1.4M and the margin 13% they will get a bonus related to the 200k they made that should be calculated by the 200k * for the margin that they made.
then we will have 1.4m to 1.6m same situation and so on.
The bonus is linked if they achieve the % margin and the value
Can someone help me on this?? thanks
Hi rzilli ,
If you have a table contians margin and bonus rate, you could use switch function to create measure.
https://docs.microsoft.com/en-us/dax/switch-function-dax .
If you want detailed formula, please share some sample data and expected result.
Best Regards,
Jay
1 Reply
Hi rzilli ,
If you have a table contians margin and bonus rate, you could use switch function to create measure.
https://docs.microsoft.com/en-us/dax/switch-function-dax .
If you want detailed formula, please share some sample data and expected result.
Best Regards,
Jay