RangeSum with date in the past

[alangho]

Hi tohether,

i had a problem with rangeSum.

I need the cumulated sum for the actual and the previous year.

For the actual year it works fine with:

=rangesum(above(sum([Umsatz.Verkauf (MW)]), 0, rowno()))

What i have to do for the previous year?

[sunny_talwar]

What is your expression for the Umsatz 2017 column?

[alangho]

sum({<Jahr={$(#=only(Jahr)-1)}>}[Umsatz.Verkauf (MW)])

[sunny_talwar · Accepted solution]

Is this not working then?

=RangeSum(Above(Sum({<Jahr = {$(#=only(Jahr)-1)}>} [Umsatz.Verkauf (MW)]), 0, RowNo()))

[alangho]

Thanks it's working fine now.