Compare reported monthly bonus with reported annual salaries

[TamirBasin]

Hello,

1. Salaries are reported annually. However, they can change each month.


2. Bonuses are paid irregularly over different months.


I am trying to achieve:
Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting a YEAR from the year slicer, I would like the Salary of DEC of that year.
Please see link for the file.

https://basintamir-my.sharepoint.co...JGpYaV4f-6m44BbHNNXzk8vrdtkxzV-bWE7g?e=NFgKW3

Thank you

Tamir