Hi,
Looking for some help if anyone has any idea on how to do this. What I need is a calculation in PowerBI, where the user can both change both one of the inputs, or change the output, to see the outcomes.
Simplified, the calculation is I have so many hours of work, at a Cost per hour, equals the total cost:
Hours X CPH = TotalCost
So I have a whatif on the Hours, so the user can adjust the number of hours and see how that effects the total cost. However, what the user also wants to be able to do is in the same calculation, to adjust the total cost and to see what the number of hours would be as a result. So the user can adjust the number of hours and see the total cost, but also adjust the total cost and see the number of hours. CPH always remains fixed. So both Hours and TotalCost are calculated fields, but also the user can write in to them.
Anyone know if there is any way to do this?
Thanks All!
Looking for some help if anyone has any idea on how to do this. What I need is a calculation in PowerBI, where the user can both change both one of the inputs, or change the output, to see the outcomes.
Simplified, the calculation is I have so many hours of work, at a Cost per hour, equals the total cost:
Hours X CPH = TotalCost
So I have a whatif on the Hours, so the user can adjust the number of hours and see how that effects the total cost. However, what the user also wants to be able to do is in the same calculation, to adjust the total cost and to see what the number of hours would be as a result. So the user can adjust the number of hours and see the total cost, but also adjust the total cost and see the number of hours. CPH always remains fixed. So both Hours and TotalCost are calculated fields, but also the user can write in to them.
Anyone know if there is any way to do this?
Thanks All!
