Forum Discussion

Edgar_massa's avatar
Edgar_massa
Helper II
3 years ago
Solved

balance calculation

Good night guys Here's the thing, I have a bank balance table that brings me the balance on the 1st of each month, and I have a fact table containing my realized balance (income - expense). I need ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Edgar_massa's avatar
    Edgar_massa
    2 years ago

    Good afternoon

    I managed to solve it as follows

     

        VAR Saldo1 = [Saldo Realizado] + [Saldo de Contas]

        VAR Calc =
        CALCULATE(
            [Saldo Realizado] + [Saldo de Contas],
            FILTER(
                ALLSELECTED(
                    dim_Calendario),
                    [Saldo Realizado] + Saldo1 ),
                   
                    dim_Calendario[Data] <= MAX(dim_Calendario[Data])
        )
     

     

     
    Very similar to your solution danextian 
     
    Very Thanks
     
Edgar_massa's avatar
Edgar_massa
Helper II
2 years ago

Good afternoon

I managed to solve it as follows

 

    VAR Saldo1 = [Saldo Realizado] + [Saldo de Contas]

    VAR Calc =
    CALCULATE(
        [Saldo Realizado] + [Saldo de Contas],
        FILTER(
            ALLSELECTED(
                dim_Calendario),
                [Saldo Realizado] + Saldo1 ),
               
                dim_Calendario[Data] <= MAX(dim_Calendario[Data])
    )
 

 

 
Very similar to your solution danextian 
 
Very Thanks