Fixed measure across empty rows

[AU555]

Hi all,

my problem has probably very easy solution, but as I am not too experienced I simply cannot figure it out. I have a task to calculate predicted expenses for the next years, so far only the actual expenses for 2019 are known. Then for years 2019, 2020 and 2021 we have exected expenses. The preducted expenses should be simply calculated as: 

predicted expnses = expected expenses * rate

rate = actual expenses / expected expenses

This is a sample of how it currently looks like: the rate is of course calculated only in year 2019, since that is the only year we know the actual expenses. Thus, the prediction for years 2020 and 2021 also stays empty, as rate is emplty. But I would like to make the measure rate fixed, so it is in all the rows and thus based on that calculate the prediction. 

so then final table would look like this: 

Can somebody help? 🙂 

[amitchandak · Accepted solution]

@AU555 , Based on what I got , Try a measure like

measure =
var _rate = calculate(lastnonblankvalue(Table[year], [Rate]), allselected(Table)
return
[expected]*_rate