How to insert information in another table based in the day

I have two tables:

Table A: This is where the initial amount is stored

Table B: Here are the transactions made each day, where an account can have more than one transaction

Challenge/problem/no idea how to do it :man_shrugging: :man_shrugging: :thinking:

At the end of the day, when you enter the final balance of transactions for each account, update with that day’s total amount in Table A to find the difference that remains

The question is, how do I do this?

Many thanks for your help!!

@Juan_Gutierrez
Below expression will give you the total end of day transactions for any specified account. Create a Virtual Column in Table A:

SUM(
    SELECT(
        TableB[End Balance],
        [Accounts] = [_THISROW].[Account]
    )
)
3 Likes

Great!!!
I’m going to do it and I’ll be back to comment on the result