Calculate Total Time Spent by Employees - Power Query Challenge 03 (Step-by-Step Tutorial)
Hello and welcome! In this video, we dive into a Power Query challenge presented by Vijay Verma. Our task is to calculate the total time spent by various people using a provided dataset. Follow along to learn a step-by-step solution to this challenge and enhance your Power Query skills.
If you find this video helpful, please give it a thumbs up and subscribe to my channel for more Power Query tips and challenges. Thank you for watching!
Links:
Vijay A. Verma:
1) LinkedIn Profile: / excelbi
2) Download the file: lnkd.in/dTpfRT3H
3) Original post: / urn:li:activity:721339...
'Power Query Challenges' Playlist: • Power Query Challenges...
Timestamps:
00:00 - Introduction to the challenge
00:24 - Loading data into Power Query
00:36 - Splitting the first column using a custom delimiter
00:52 - Creating a custom column to calculate the duration
01:08 - Converting values to hours
01:30 - Unpivoting columns to untangle the table
01:48 - Summarizing the data with Group By
02:07 - Conclusion and additional tips
#PowerQuery #MicrosoftExcel #DataTransformation #ExcelTips #PowerQueryChallenge #DataAnalysis #ExcelTutorial
Негізгі бет Calculate Total Time Spent by Employees - Power Query Challenge 03
No video
Пікірлер