Assistance accumulating and dividing monthly totals to find YTD percentage

[crumy]

I am new to Power BI and I have searched several different scenarios and I am not finding what I need. I believe this should be fairly simple for those experienced. 

I need to produce a report that that shows how many hours per month have been worked  and show a perccentage that shows the performance against target.    (Sum of all months actuals and divided by the Target).  

I have created the relationship between the two tables based on month name and that is working.    

I can not figure out how to take the total of hours and divide by the YTD Target hours from the other table..     

Data:
One table with information regarding hours worked in a month along with associate. (actuals)
One table with Month names, hours per month and an accumulated YTD total for hour  that should be worked  (target)

Output

I can not figure out how to take the total of hours and divide by the YTD Target hours from the other table..      I do not how to solve the cells highlighed in Green. 

Thank you in advance!

[crumy]

This was very helpful.  Thank you for the easy to follow explanation and code sample. 

[Kishore_Kadhir · Accepted solution]

Hi,

You can try the below steps:

1. Create a calculated column in YTD target table with the below DAX: 

Index = IF('YTD'[Month]="Jan",1, IF('YTD'[Month]="Feb",2, IF('YTD'[Month]="Mar",3))) - There are better ways to write this DAX but let's not get into that

2. Create a measure with the following DAX:

YTD % = CALCULATE(SUM(Resource[Hours]), FILTER(ALL('YTD'), 'YTD'[Index] <= MAX('YTD'[Index]))) / SUM('YTD'[YTD Hours])

 Hope this solves your problem. If it does, please consider accepting this as solution.

Regards,

Kishore