Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jasleen_kaur
Frequent Visitor

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 SinhaSoftware DevelopmentCoding####################03:07Asset Mgtforms design Chhagan SinhaChhagan Sinhachhagan.sinha@credentinfotech.com07-04-2023 10:0707-04-2023 10:0702-01-1900 05:2106-01-1900 05:2130-12-1899 12:21 PM
Chhagan SinhaSoftware DevelopmentCoding####################01:09Asset Mgtcompanies page form design of asset management applicationsChhagan SinhaChhagan Sinhachhagan.sinha@credentinfotech.com07-04-2023 10:0907-04-2023 10:0931-12-1899 05:21 AM08-01-1900 05:2130-12-1899 12:21 PM
Chhagan SinhaSoftware DevelopmentUnit Testing####################01:59PhishingTesting functionalities of Campaign page of applicationsChhagan SinhaChhagan Sinhachhagan.sinha@credentinfotech.com07-04-2023 10:1207-04-2023 10:1231-12-1899 05:21 AM27-02-1900 05:2130-12-1899 12:21 PM
Chhagan SinhaSoftware DevelopmentBug Fixing####################01:14Phishingimport recipient's functionality.Chhagan SinhaChhagan Sinhachhagan.sinha@credentinfotech.com07-04-2023 10:1607-04-2023 10:1631-12-1899 05:21 AM13-01-1900 05:2130-12-1899 12:21 PM
Chhagan SinhaSoftware DevelopmentCoding####################01:09Asset MgtDashboard ImplementationChhagan SinhaChhagan Sinhachhagan.sinha@credentinfotech.com07-04-2023 10:1807-04-2023 10:1831-12-1899 05:21 AM08-01-1900 05:2130-12-1899 12:21 PM
Vinit KumarSoftware DevelopmentWork Flows####################00:30PICheck Escalation Mail on PI Environment.Vinit KumarVinit Kumarvinit.kumar@credentinfotech.com10-04-2023 14:3510-04-2023 14:3530-12-1899 05:21 AM29-01-1900 05:2130-12-1899 12:21 PM
Jasleen  KaurOrganisational TasksTeam meeting####################00:38Credent websitewith Sunil sir:
Discussion about CIS website UI changes.
weekly report remainder
Jasleen  KaurJasleen  Kaurjasleen.kaur@credentinfotech.com10-04-2023 14:4710-04-2023 14:4530-12-1899 05:21 AM06-02-1900 05:2130-12-1899 12:19 PM
Jasleen  KaurProject ManagementProject Tracking####################00:11PIPI weekly reportJasleen  KaurJasleen  Kaurjasleen.kaur@credentinfotech.com10-04-2023 14:4810-04-2023 14:4830-12-1899 05:21 AM10-01-1900 05:2130-12-1899 12:21 PM
Jasleen  KaurProject ManagementProject Tracking####################00:01Renew weekly reportJasleen  KaurJasleen  Kaurjasleen.kaur@credentinfotech.com10-04-2023 14:5010-04-2023 14:5030-12-1899 05:21 AM31-12-1899 05:21 AM30-12-1899 12:21 PM
1 ACCEPTED SOLUTION
Jasleen_kaur
Frequent Visitor

can you help me calculating Employee wise date missing (avoid Sat and Sun)in timkeeping dashboard?

View solution in original post

2 REPLIES 2
Jasleen_kaur
Frequent Visitor

can you help me calculating Employee wise date missing (avoid Sat and Sun)in timkeeping dashboard?

Idrissshatila
Super User
Super User

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 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.