Hello,
I am new in power BI, I have dataset named as Timekeeping. I want to build a timekeeping dashboard. whereas, user do multiple entries per day. I want help in few requirements:
1. Employee wise date missing (avoid Sat and Sun)
2. Employee wise total no. of Hours (day Wise/ Week Wise/ Month Wise
how to calculated this?
Here is the dataset:
NameCategorySubCategoryStarttimeEndTimeTotalWorkingHoursProjectDescriptionCreated ByModified ByUserEmailModifiedCreatedTotalWorkingHHTotalWorkingMMHoursperdayColumn1
| Chhagan Sinha | Software Development | Coding | ########## | ########## | 03:07 | Asset Mgt | forms design | Chhagan Sinha | Chhagan Sinha | chhagan.sinha@credentinfotech.com | 07-04-2023 10:07 | 07-04-2023 10:07 | 02-01-1900 05:21 | 06-01-1900 05:21 | 30-12-1899 12:21 PM |
| Chhagan Sinha | Software Development | Coding | ########## | ########## | 01:09 | Asset Mgt | companies page form design of asset management applications | Chhagan Sinha | Chhagan Sinha | chhagan.sinha@credentinfotech.com | 07-04-2023 10:09 | 07-04-2023 10:09 | 31-12-1899 05:21 AM | 08-01-1900 05:21 | 30-12-1899 12:21 PM |
| Chhagan Sinha | Software Development | Unit Testing | ########## | ########## | 01:59 | Phishing | Testing functionalities of Campaign page of applications | Chhagan Sinha | Chhagan Sinha | chhagan.sinha@credentinfotech.com | 07-04-2023 10:12 | 07-04-2023 10:12 | 31-12-1899 05:21 AM | 27-02-1900 05:21 | 30-12-1899 12:21 PM |
| Chhagan Sinha | Software Development | Bug Fixing | ########## | ########## | 01:14 | Phishing | import recipient's functionality. | Chhagan Sinha | Chhagan Sinha | chhagan.sinha@credentinfotech.com | 07-04-2023 10:16 | 07-04-2023 10:16 | 31-12-1899 05:21 AM | 13-01-1900 05:21 | 30-12-1899 12:21 PM |
| Chhagan Sinha | Software Development | Coding | ########## | ########## | 01:09 | Asset Mgt | Dashboard Implementation | Chhagan Sinha | Chhagan Sinha | chhagan.sinha@credentinfotech.com | 07-04-2023 10:18 | 07-04-2023 10:18 | 31-12-1899 05:21 AM | 08-01-1900 05:21 | 30-12-1899 12:21 PM |
| Vinit Kumar | Software Development | Work Flows | ########## | ########## | 00:30 | PI | Check Escalation Mail on PI Environment. | Vinit Kumar | Vinit Kumar | vinit.kumar@credentinfotech.com | 10-04-2023 14:35 | 10-04-2023 14:35 | 30-12-1899 05:21 AM | 29-01-1900 05:21 | 30-12-1899 12:21 PM |
| Jasleen Kaur | Organisational Tasks | Team meeting | ########## | ########## | 00:38 | Credent website | with Sunil sir:
Discussion about CIS website UI changes.
weekly report remainder | Jasleen Kaur | Jasleen Kaur | jasleen.kaur@credentinfotech.com | 10-04-2023 14:47 | 10-04-2023 14:45 | 30-12-1899 05:21 AM | 06-02-1900 05:21 | 30-12-1899 12:19 PM |
| Jasleen Kaur | Project Management | Project Tracking | ########## | ########## | 00:11 | PI | PI weekly report | Jasleen Kaur | Jasleen Kaur | jasleen.kaur@credentinfotech.com | 10-04-2023 14:48 | 10-04-2023 14:48 | 30-12-1899 05:21 AM | 10-01-1900 05:21 | 30-12-1899 12:21 PM |
| Jasleen Kaur | Project Management | Project Tracking | ########## | ########## | 00:01 | Renew | weekly report | Jasleen Kaur | Jasleen Kaur | jasleen.kaur@credentinfotech.com | 10-04-2023 14:50 | 10-04-2023 14:50 | 30-12-1899 05:21 AM | 31-12-1899 05:21 AM | 30-12-1899 12:21 PM |
