Forum Discussion
Matrix selection with two tables not connected directly
Hi,
I have a model like the picture below.
I need to create a Matrix using the table 2 (Cash Balances) and 3 (cash Ledger). The table 2 contains the inicial Balance and the 3 contains the movements. To get the Final Balance I have to sum the results of 2 plus the result of 3 on depending de date.
My problem is that if I want to use a Matrix with the company name (table 1) I have no direct link between 1 and 3.
I'm using the formula below, but as I say, I cannot link it with Companies. Could you help me? thank you
CALCULATE(SUM(CASH_BALANCES[ACTUAL_FORECAST]), filter(ALLEXCEPT(CASH_BALANCES, CASH_BALANCES[ACC_CODE],ACCOUNTS[ACC_CODE], BANKS[BANK_CODE],BANKS[DESCRIPTION]),CASH_BALANCES[BALANCE_TYPE] = -1))
1 Reply
joaquinel , Looking at the joins, you should be able to analyze data together across common tables(Like Date)
