cancel
Showing results for
Did you mean: Helper I

## Fixed measure across empty rows

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? 🙂

1 ACCEPTED SOLUTION Super User IV

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

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

Proud to be a Super User! Super User IV

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

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