Calculated sum Related to another table / list

[SvenJ]

Good morning everyone,

i have the following orignal list, where i receive the values, which need to be calculated (ENTRY LIST)

And this is the orginal table 

The result should look like this (FINAL_TABLE)

And here is what i need:

• The FINAL TABLE should look in the ENTRY LIST, if the column Konto is between "Konto from" to "Konto to" and write the difference between EINGANG and AUSGANG in the correct column & row of the MONAT (1-12) / f.ex. B_No 1020
• In B_No "1051" should be the sum of all rows between B_No from (1020) and B_No to (1045)

At the end i want to fill a matrix table with this values. Can anyone help me?

[v-robertq-msft]

Hi, 

Have you followed the DAX formula posted by amitchandak to find the solution to your problem?

If so, would you like to mark his reply as a solution so that others can learn from it too?

If you still have a problem, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@SvenJ , Based on what I got

You can add new column in Table 2 from Table1

Sumx(Filter(Table1, Table1[Kontoto] >= Table2[Konto From] && Table1[Kontoto] <= Table2[Konto to]) , [EINGANG] -  [AUSGANG])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.