Forum Discussion

Rafael_Batista_'s avatar
Rafael_Batista_
Regular Visitor
2 years ago
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 ...
Need Help
  • Rafael_Batista_'s avatar
    Rafael_Batista_
    2 years ago
    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
Rafael_Batista_'s avatar
Rafael_Batista_
Regular Visitor
2 years ago

Hi

This is the format I am using, where the [Saldo] is the value of the balance and the [Saldo Realizado] is the result of Revenue - Expense

Can you help me make the correction?