Forum Discussion
Solved
Timesheet Dashboard
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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 |
can you help me calculating Employee wise date missing (avoid Sat and Sun)in timkeeping dashboard?
2 Replies
Hello Jasleen_kaur ,
this video will help you acheive what you're asking for https://youtu.be/6JA6uy3ZRBA
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
can you help me calculating Employee wise date missing (avoid Sat and Sun)in timkeeping dashboard?
