Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors