Using while-loop to increment an adder by 1 each time it sees a value

[Anonymous]

table1

year	forecasted_month
2023	12
2023	1
2023	2

I have a table that looks like this and I want to create a new column called forecasted_year where it adds 1 to year whenever forecasted_month hits 1 again.

My expected outcome would look like this if it works as intended

forecasted_year

2023

2024

2024

Is there any way to do this in DAX or Power Query? 

[lbendlin]

Neither DAX nor Power Query have a concept of mutable variables. You need to bring your own index column to make this work.