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.
I have two tables:
Table Jobs:
ID; Name; TaskID
1; Job1; 1
2; Job1 ;3
3; Job1; 3
4; Job2; 2
5; Job2; 3
6; Job2; 3
7; Job3; 1
8; Job4; 2
9; Job4; 1
and a table with costs for a specific task.
Table Task:
ID; Name; €
1; Cleaning; 5
2; Testing; 10
3; Replacing; 20
I created a relation between Jobs.TaskID and Task.ID. How to get the sum (€) of tasks of a job? I like to get the following output:
Job1; 45
Job2; 50
Job3; 5
Job4; 15
I got only the following output:
That’s quite different as expected. Any ideas how to get the sum (€) of each job?
Kind regards
Christoph
Solved! Go to Solution.
The Power Query Editor served exactly what I needed. Go to Combine and create the relation there.
Then the model shows exactly what I need:
Thanks a lot! 😊
The Power Query Editor served exactly what I needed. Go to Combine and create the relation there.
Then the model shows exactly what I need:
Thanks a lot! 😊
try to
1) remove the TaskID from the table visual.
2) Jobs Table and Task Table shall be related one-to-many. Is that the case?
Thanks for your reply!
Removing the TaskID doesn't fix it.
Yes, related one-to-many is correct.
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 |
---|---|
102 | |
101 | |
78 | |
70 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |