Forum Discussion
Solved
Balance Calculation in Power BI
Good afternoon! I need to do a balance calculation in Power BI, where I have the columns of Revenue, Expense and BalanceThe operation should work each day that there was movement, so it will take ...
- Solucion:
Balanço =VAR DataAtual = MAX('CR - Saldo'[Data])var _PagoAcum =CALCULATE([Saldo Realizado],FILTER(ALLSELECTED('CR - Saldo'),'CR - Saldo'[Data] <= DataAtual))RETURN[Saldo] + _PagoAcum
Solucion:
Balanço =
Balanço =
VAR DataAtual = MAX('CR - Saldo'[Data])
var _PagoAcum =
CALCULATE(
[Saldo Realizado],
FILTER(
ALLSELECTED('CR - Saldo'),
'CR - Saldo'[Data] <= DataAtual))
RETURN
[Saldo] + _PagoAcum