Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question