Budget hours vs. FTE

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. 

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