Forum Discussion
CALCULATE WITH DYNAMIC VALUES
Hello, Iam looking to calculate salaries after bonuses have been allocated. Bonuses must be defined by the final user in power BI. For this, I generated a series of 0 to 20% that I want to assi...
sturlaws Hey thank you for the reply!
would you please implement the solution using power automate in power BI that i can see how it works. You can do it for 2 or 3 persons and share the result with me please ?
The use case is: As an "HR manager" user, I must be able, from the BI report, to select/define the Bonus percentage for each employee and to see calculated automatically the new salary/employee integrating the bonus in order to be able to follow the budgetary bonus envelopes and payroll.
The case will cover 200 to 300 employee. So the solution has to be handled automatically via a function.
Thanks!
Ben
For that many users it is not doable, as you would have to create a slicer for each user, and it won't be dynamic