Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
@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
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 10
Did I write something wrong?
This is an answer
User | Count |
---|---|
52 | |
48 | |
20 | |
16 | |
15 |
User | Count |
---|---|
109 | |
45 | |
42 | |
24 | |
20 |