Forum Discussion
Solved
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 a...
AU555 , Based on what I got , Try a measure like
measure =
var _rate = calculate(lastnonblankvalue(Table[year], [Rate]), allselected(Table)
return
[expected]*_rate
AU555 , Based on what I got , Try a measure like
measure =
var _rate = calculate(lastnonblankvalue(Table[year], [Rate]), allselected(Table)
return
[expected]*_rate