Average Duration Time - Power Query Challenge 23

Average Duration Time - Power Query Challenge 23

In this video, we tackle a data analysis challenge: calculating the average cooperation time for employees still with the company as of a given date. We start by filtering the data to focus on current employees, group it by employee levels, and then calculate the average time they have been with the company. Watch as we walk through the entire process, including a detailed formula to convert days into months. Perfect for data enthusiasts looking to enhance their skills with practical examples!

Timestamps:
00:00 - Introduction to today's challenge
00:13 - Filtering data to focus on current employees
00:27 - Grouping data by employee levels
00:41 - Calculating average cooperation time
00:56 - Using the duration days function in the formula bar
01:18 - Converting average days to months
01:46 - Wrapping up the challenge and final thoughts

Links:
CHALLENGE AUTHOR: Omid Motamedisedeh
3) Download Workbook:
4) Omid's YouTube Channel:

#PowerQuery #PowerQueryChallenge #ExcelChallenge #HowToLearnExcel

[vishalmehta]

What is "list.average" function?

[ahmedshalaby]

if i have time like 2:23 2mins and 23 seconds how i can make measure based on both and we need more lessons about M language