Forum Discussion
Solved
Daily final amount average
Hello,
Could you help me with dax formula.
I need to calculate simple average of daily cummulative final amount as shown in the example below:
| Date | Inflow | Outflow | Final amount | Cummulative final |
| 2021-01-01 | 100 | -50 | 50 | 50 |
| 2021-01-02 | 200 | 200 | 250 | |
| 2021-01-03 | 300 | -200 | 100 | 350 |
| 2021-01-04 | -50 | -50 | 300 | |
| 2021-01-05 | -200 | -200 | 100 | |
| 2021-01-06 | 500 | 500 | 600 | |
| 2021-01-07 | 496 | -150 | 346 | 946 |
| 2021-01-08 | 300 | 300 | 1246 | |
| 2021-01-09 | 5616 | -3468 | 2148 | 3394 |
| 2021-01-10 | 16 | 16 | 3410 | |
| 2021-01-11 | 0 | 3410 | ||
| Dayly average | 1278 |
5 Replies
Hi,
What does your source data look like? Do you simply want to show 1,278 on a card visual?
Hi, thanks for propt reaction. It could be a measure, there is no need to see every day result.
Iš will be in the table by category
You have answered my second question - that you want to see the result in a card visual. Please answer the first one - share your source data which i can copy into an MS Excel workbook. Else, share the download link of your PBI file.
