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 )
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.