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.
Hi everybody,
I have this situation:
Day | Person | Project | Hours |
01/01/2021 | Marco | Alpha | 4 |
02/01/2021 | Marco | Beta | 4 |
02/01/2021 | Marco | Alpha | 8 |
04/05/2021 | Marco | Alpha | 4 |
01/03/2021 | Marco | Beta | 4 |
My aim is to have for each project / person the total number of hours and the first and last date of work.
Something like this
Person | Project | Hours | First Date | Last Date |
Marco | Alpha | 12 | 01/01/2021 | 04/05/2021 |
Marco | Beta | 8 | 02/01/2021 | 01/03/2021 |
how can I do?
Thanks
Marco
Solved! Go to Solution.
@marpisa , In a table of Matrix, take you can person and project on row. Sum of the hour as value and min and max of Day as first and last date
But why the first on is 12 not 16?
@marpisa , In a table of Matrix, take you can person and project on row. Sum of the hour as value and min and max of Day as first and last date
But why the first on is 12 not 16?
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |