Forum Discussion
Helper IIICalculated sum Related to another table / list
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?
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.
2 Replies
- amitchandak
Super User
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. - v-robertq-msft
Community Support
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.
