Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
At the end i want to fill a matrix table with this values. Can anyone help me?
Solved! Go to 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.
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |