#10160

Опубликовано: 05 Май 2025
на канале: I'mmalytics

📊 Dive deep into Power Query with our comprehensive course! We're regularly adding new lessons to keep you ahead of the curve.

💻 Downloadable study materials and datasets are on their way – stay tuned for announcements!

01:45 – 📅 Exploring the "Transform" tab date functions in Power Query
02:40 – 🔢 Extracting Year and applying "Start of Year" and "End of Year" functions
03:10 – ⚠️ Warning: "End of Year" might return Jan 1 of next year if time data isn't cleaned
03:45 – 🗓️ Getting "Start of Month" and extracting "Month Name"
04:20 – 📆 Using "Days in Month" to show number of days per date row
05:15 – 🧠 Aggregating with "Earliest" and "Latest" dates in a column
05:50 – 🕒 Calculating "Age" from date column to current date, returning Duration format
06:20 – ⏱️ Explaining duration format (days, hours, minutes, seconds)
07:30 – 🔍 Extracting only Days, Hours, or Minutes from Duration
08:30 – 📊 Using "Statistics" to get average and other aggregations
09:30 – 🧾 Creating a custom column to calculate difference between HireDate and BirthDate