Fill in year values for every month

[LLT1021]

Dear all,

I have a question about adding year values for every month.
I have a table scores per person per year, the score table looks like;
Year      Person      Score       Date-Person key
2022      Ben           5            01-01-2022 Ben
2021      Ben           2            01-01-2021 Ben

2020      Ben           3            01-01-2020 Ben
2022      Michel      3            01-01-2022 Michel
2021     Michel        1          01-01-2021 Michel

Etc.

I would like to use these scores in another table with lots of more information for every person, but per month. 
If I use Score=related(Score[Score]) I get the score for every person but only on the first of a year. Therefore, if you select another time period (January excluded) you don't get a score for anyone, though the score is valid for all of the year.

Does anyone know how to solve this easily?

[LLT1021]

Thanks a lot! This is already helping very much.
Though, I only have values on 1-1-year (so not in the end of the year), which dax expression would the nbe appropriate? 

[amitchandak]

@LLT1021 , refer if these can help

PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...