Forum Discussion

RMV's avatar
RMV
Icon for Helper V rankHelper V
8 years ago
Solved

balance from 2 tables

Hi, I have 2 tables from separate database for the same fields structure. We used the old database during 2016 and prior and then we moved to the new database for 2017 transactions and move some ba...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI RMV

     

    In that case

     

    New Table =
VAR RowstoExclude =
    FILTER (
        OldDatabase,
        OldDatabase[Entity] = "A"
            && OldDatabase[Date] > DATE ( 2016, 11, 30 )
    )
RETURN
    UNION ( EXCEPT ( OldDatabase, RowstoExclude ), NewDatabase )
RMV's avatar
RMV
Icon for Helper V rankHelper V
8 years ago

Hi Zubair_Muhammad,

 

Thanks for your advise.

The thing is for entity A data, I only need transactional data until Nov 2016 to calculate the accumulated balance.

Then Dec 2016 will take the total amount from the new database. The following monts ahead use accumulated balance of the transactional data from the new database.

While for entity B, the accumulated balance is all from the old database.

Any advise, please?

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI RMV

 

In that case

 

New Table =
VAR RowstoExclude =
    FILTER (
        OldDatabase,
        OldDatabase[Entity] = "A"
            && OldDatabase[Date] > DATE ( 2016, 11, 30 )
    )
RETURN
    UNION ( EXCEPT ( OldDatabase, RowstoExclude ), NewDatabase )
  • RMV's avatar
    RMV
    Icon for Helper V rankHelper V
    8 years ago

    Hi Zubair_Muhammad,

     

    Got it! Thanks for your help.