- I’m trying to add 2 new columns to my business leader table: min date and max date of my timesheet table. I’ve tried with lookupvalue function and of course, it didn’t work. Don’t know why.
- Once this it’s done, i need a measure to show me the total hours worked for any employee, as well as the due to work, accordingly the selected dates on the report. Let me give you an example of what i need:
If i select a period in my report, like from January 1st till January 10, it’s suppose to show me only the hours of each employee that max date is after 10 of January.
Real Example: min date of Employee ID 381 is 6 of Jan. He has worked 4 days, According to timesheet table, which means 32 hours. According to our dates table, on Day Type column, he has worked 3 days on weekdays and 1 on weekend, which means the total of due work is 24 hours.
I’m attaching a file
Can anyone help me?
Thanks a lot
TM.xlsx (24.3 KB)