hello everyone
I've been trying for two days to be able to get a running total in Dax power pivot with no success see below how i want it any help is greatly appreciated
I've been trying for two days to be able to get a running total in Dax power pivot with no success see below how i want it any help is greatly appreciated
| Book1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | AR by Bucket | BucketName | |||||||||
| 2 | CUST NO | NAME | INV NO | INV DATE | - 0 Days (cred) | 0-30 Days | 31-60 Days | 61-90 Days | Running Total | ||
| 3 | 000001 | jacks store | 1 | 1/6/2025 | $15.00 | $15.00 | |||||
| 4 | 2 | 1/7/2025 | $25.00 | $40.00 | |||||||
| 5 | 3 | 1/14/2025 | $16.00 | $56.00 | |||||||
| 6 | 4 | 1/21/2025 | $17.00 | $73.00 | |||||||
| 7 | 5 | 1/29/2025 | $14.00 | $87.00 | |||||||
| 8 | 6 | 2/4/2025 | $15.00 | $102.00 | |||||||
| 9 | 7 | 2/12/2025 | $16.00 | $118.00 | |||||||
| 10 | 8 | 2/19/2025 | $17.00 | $135.00 | |||||||
| 11 | 9 | 2/19/2025 | $17.00 | $152.00 | |||||||
| 12 | 10 | 2/25/2025 | $100.00 | $252.00 | |||||||
| 13 | 11 | 3/4/2025 | $200.00 | $452.00 | |||||||
| 14 | 12 | 3/11/2025 | $300.00 | $752.00 | |||||||
| 15 | 13 | 3/11/2025 | $400.00 | $1,152.00 | |||||||
| 16 | 14 | 3/12/2025 | $500.00 | $1,652.00 | |||||||
| 17 | 15 | 3/18/2025 | $600.00 | $2,252.00 | |||||||
| 18 | 16 | 3/18/2025 | $700.00 | $2,952.00 | |||||||
| 19 | x17 | 1/14/2025 | ($0.71) | $2,951.29 | |||||||
| 20 | x18 | 3/7/2025 | ($96.00) | $2,855.29 | |||||||
| 21 | 000001 Total | ($96.71) | $2,800.00 | $79.00 | $73.00 | $2,855.29 | |||||
Sheet1 | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E21:H21 | E21 | =SUM(E3:E20) |
| I21 | I21 | =SUM(E21:H21) |
