Forum Discussion

Luca2020's avatar
Luca2020
Helper I
5 years ago
Solved

Column with TOTALYTD

Hi,  I need a column (or a different new table but not a measure) with the total amount € for each account from 1 january to 31 december previous year, like:    account        amount     1       ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Luca2020 , This will a year behind column


    new column =
    var _date = date(year([date])-1,month([date]),day([date]))
    return
    sumx(filter(Table, [date] =_date &&[account] = earlier([account])),[amount] )

     

    in case you want to sum up last year till date

     

    new column =
    var _max = date(year([date])-1,month([date]),day([date]))
    var _min = date(year([date])-1,1,1)
    return
    sumx(filter(Table, [date] >=_min && [date]<=_max &&[account] = earlier([account])),[amount] )

amitchandak's avatar
amitchandak
Super User
5 years ago

Luca2020 , This will a year behind column


new column =
var _date = date(year([date])-1,month([date]),day([date]))
return
sumx(filter(Table, [date] =_date &&[account] = earlier([account])),[amount] )

 

in case you want to sum up last year till date

 

new column =
var _max = date(year([date])-1,month([date]),day([date]))
var _min = date(year([date])-1,1,1)
return
sumx(filter(Table, [date] >=_min && [date]<=_max &&[account] = earlier([account])),[amount] )