Forum Discussion
Acumulate value
Hello, I have a dataset like this
index number amount balance
1 10775 10 10
2 10775 -10 0
3 10775 20 20
4 10775 -20 0
5 10775 10 10
6 10775 10 20
7 10775 10 30
8 10776 10 10
9 10776 10 20
10 10776 -10 10
11 10776 10 20
I would like to get the Number of column balance acumulated by number group.
Thanx in advance for help
3 Replies
This is an answer
balance =CALCULATE (SUMX ( 'Table', [amount] ),FILTER (ALLEXCEPT ( 'Table', 'Table'[number] ),'Table'[index] <= MAX ( 'Table'[index] )))geerduran , New measure
calculate(sum(Table[amount]) , filter(allselected(Table), table[number] = max(table[number]) && table[index] = max(table[index])))
new column
sumx( filter(Table, table[number] = earlier(table[number]) && table[index] = earlier(table[index])),Table[amount])
Thanks amitchandak , but balance is same as amount with new column code
balance = sumx( filter(table, table[number] = earlier(table[number]) && table[index] = earlier(table[index])),table[amount])index number amount balance
1 10775 10 10
2 10775 -10 -10
3 10775 20 20
4 10775 -20 -20
5 10775 10 10
6 10775 10 10
7 10775 10 10
8 10776 10 10
9 10776 10 10
10 10776 -10 -10
11 10776 10 10Did I write something wrong?
