Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

Fill in year values for every month

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


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?

Helper I
Helper I

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? 

Super User
Super User

@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:


powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target):

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.