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.
Hello there!
I have an odd problem that I can't seem to wrap my mind around. I have a table formatted like this:
ID | Employee | Hours | Cause | Materials | Material Hours | |
F544.070 | Employee 1 | 1 | Fire | Truck 1 | 1 | |
F544.070 | Employee 1 | 1 | Fire | Truck 2 | 1 | |
F544.070 | Employee 2 | 2 | Fire | Truck 3 | 1 | |
F544.070 | Employee 2 | 2 | Fire | Truck 4 | 1 | |
F544.070 | Employee 3 | 1 | Fire | Truck 5 | 1 | |
F544.070 | Employee 3 | 1 | Fire | Truck 6 | 1 | |
F544.070 | Employee 4 | 2 | Fire | Truck 7 | 1 | |
F544.070 | Employee 4 | 2 | Fire | Truck 8 | 1 | |
F544.070 | Employee 5 | 3 | Fire | Truck 9 | 1 | |
F544.070 | Employee 5 | 1 | Fire | Truck 10 | 1 | |
F544.070 | Employee 6 | 1 | Fire | Truck 11 | 1 | |
F544.070 | Employee 6 | 1 | Fire | Truck 12 | 1 |
This report is used to track employees, hours spent on the job, what job they responded to, and the materials used on the job. Unfortunately there are ALWAYS more materials corresponding to a jon (ID) number so it formats like the about, i.e. creating more information. It can be duplicates, triplicates, etc etc depending on how many materials are used on the job.
So when I want to sum the hours for the employee on a particular job it is not correct. Is there a way to get a distinct sum based off of the ID number?
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |