Forum Discussion

AU555's avatar
AU555
Icon for Helper I rankHelper I
5 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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

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