A
A
Aizharik2019-09-14 11:37:28
excel
Aizharik, 2019-09-14 11:37:28

Calculating powerbi balances?

I have something like this:
| parish | consumption |
----------------------
| 500 | 0 | Date and so on
| 0 | -1000 | Date and so on
| 1500 | 0 | Date, etc.
----------------------
How to make a calculation using something like this formula:
Previous balance + balance = Income - Expense
How can I change the query so that it gets into the model extra column? Or some kind of Meru.
____________________________
| parish | consumption | Calculation |
--------------------------------
| 500 | 0 | 500 |
| 0 | -1000 | -500 |
| 1500 | 0 | 1000 |
--------------------------------
Unfortunately Google didn't help.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question