Forum Discussion
Value between days
Hello, this is my first message in this forum
I have a client who works in architecture and thinks in projects.
I want to display the values of booked hours of the employees in the visual "Matrix".
Unfortunately, I do not succeed in doing this. I use three (respectively 4) tables:
a) POS (Positions /engl. RIBA))
b) TIME (time bookings)
c) PERF (Performance level)
d) DATE table
The relational relations between the tables work.
Below are the screenshots from the sample tables:
1) Position-Table
2) Time-Bookings
3) Perf-Table
I need the number of hours per position that have accrued between the dates in the PerfTable
Below is the desired result:
EXCEL
Power BI
There is no start date and the report should ignores all hour bookings after the last PERF date of the positions.
Thanks a lot
2 Replies
Hi ubg ,
Not very clear, if convenient, you can elaborate on how this final number of hours is derived from, we can better help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, thank you very much for your reply.
I present the situation again in a different way.
Between 07/01/2023 and 01/04/2023 two employees have posted working hours on two positions of the project.
In total 128 hours.
The result in the matrix visuals is displayed correctly.The project manager irregularly estimates the progress of performance in the project.
The day of the estimation is saved in the "PERF" table.I now need in the report the number of hours between the data of the perf table.
In the example the days for position 1 until 28.01.2023 and from 29.01.2023 to 28.02.2023.
For position 2 until 01/25/2023 , from 01/26/2023 to 02/20/2023 and from 02/21/2023 to 03/29/2023.This would be the result:
Hours after the last PERF entry should not be displayed.
