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
    3 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
     
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result for a few line items.  Also, if possible, please translate the column names of the Tables in English.