The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello! I have this table:
count | id | sum |
15 | 1 | 15+10+5+3+1 |
10 | 2 | 10+5+3+1 |
5 | 3 | 5+3+1 |
3 | 4 | 3+1 |
1 | 5 | 1 |
So I need he "sum" column that will calculate the sum of "count" values starting with current id till the last, not including previous id. Thanks in advance!
Solved! Go to Solution.
Okay, I've figured it out, here is the code:
Okay, I've figured it out, here is the code: