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
Balaço =
VAR valor1 = [Saldo]
VAR pago=
CALCULATE(
[Saldo Realizado],
FILTER('Export',
'Export'[Data] <= MAX('Export'[Data])))
RETURN
pago + valor1