Forum Discussion
substract sum with single value
Hi all, I'm new with Power BI so please don't shoot me as i'm trying to understand the functions 🙂 We are building an Power BI Dashboard where we calculate how many billable hours the employ...
Your second CALCULATE likely needs to use AVERAGE, not SUM.
Hard to help without good sample data.
Hi,
I've recreated the file with sample data. Couldnt attach it in a post so uploaded it to WeTransfer https://we.tl/t-5uHyzX6SLm
I want to have the value of the Mease show = (sum of Aantal) - targethours
so in this case:
Employee 1 worked 41,25 hours that week while target is 8, so + 33,25
| Week 1 | Week 2 | |
| Employee 1 | 33,25 | 42,25 |
| Employee 2 | 24 | 25,5 |
| Employee 3 | 20 | 20 |