Hello,
A Little introduction first. I have a power Bi report that shows the actual hours per project. Now i wan't to add the consultants their targets and FTE hours.
Table 1:
Hours, Names, FTE
Table 2:
Working hours per project, Names., Month
Table 3:
Working days per month, Working hours, Target hours.
Now i would like to combine those 3 tables.
The last table show the target hours cummulative.
In Excel i would have used the vertical lookup function to determine the hours cummalative for the selected month.
That multiplied by the consultants it's FTE is his target. I am able to put this in a table.
| Naam | Max-hours p/m | Hours | FTE | Month |
| Consultant 1 | 160 | 144,6 | 1 | 2 |
| Consultant 1 | 176 | 160 | 1 | 1 |
| Consultant 2 | 160 | 160 | 1 | 2 |
| Consultant 2 | 176 | 176 | 1 | 1 |
| Consultant 2 | 176 | 176 | 1 | 3 |
| Consultant 3 | 160 | 160 | 1 | 2 |
| Consultant 3 | 176 | 176 | 1 | 1 |
| Consultant 3 | 176 | 176 | 1 | 3 |
| Consultant 4 | 160 | 128 | 0,8 | 2 |
| Consultant 4 | 176 | 136 | 0,8 | 1 |
| Consultant 4 | 176 | 144 | 0,8 | 3 |
| Consultant 4 | 176 | 8 | | 1 |
Unfortunately if i change the table into a column chart i can only count or summarize the max hours. Is there any way to solve this problem? I Tried to use a new measure, but this didn't work.
Looking forward to an reply.
Kind regards,
Onno Bremer
