How to replicate Previous Year value with current Year value

[Balaraju]

Hi All Good morning,

I have one scenario like how to replicate previous year value with current year value the data like below.

In the column is star having value for current year I wanted that value should replicate in previous year also the out put table like below.

pls help me out on this.

Thanks,

Balaraju.

[v-rzhou-msft · Accepted solution]

Hi @Balaraju ,

If [Is Star?] is in your underlying data, I suggest you to try "Fill up" function to achieve your goal.

Replace "" by "null" in [Is Star?] > Fill up

My Sample:

Result is as below.

For reference:

Fill values in a column - Power Query | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HoangHugo]

Hi, try this

new_Is_star_column = MAXX(CALCULATETABLE([data table],[Product column] =EARLIER ([Product column]),MONTH([MMM-YY column]) = MONTH(EARLIER([MMM-YY column]))), [Is start column])