dynamic weighted average measure w/o creating additional tables

[KevinCP]

Below is a screenshot of my data. I'm attempting to calculate the weighted average percentage increase in employees for weeks up to the last week of data for TY Employees. I've used the following code to do this statically: % Change in Employees YTD = CALCULATE(SUM(Hours[TY Employees])/SUM(Hours[LY Employees])-1, FILTER(WeekBridge, WeekBridge[Week]<=8)). TY Employees and LY employees are both calculated columns. The code above was used to create the card with 16.9% to the right. 

Does anyone know how to do this dynamically without creating additional tables? Please advise if you need additional information to answer the question. Thanks in advance! 

[v-chuncz-msft]

@KevinCP,

Take a good look at https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/.

[KevinCP]

Thanks! 

[v-chuncz-msft]

@KevinCP,

By the way, if it helps, you may help accept solution. Your contribution is highly appreciated.

[KevinCP]

The solution was helpful but I'm not sure that it's exactly what I'm looking for. I'm still without a solution.