Power Query Basic 12 - Basic Date Calculations
Have you ever spent too much effort in figuring out how to do a date calculation in Excel? E.g. To get the number of days of a month, or to get the starting date of a week based on a give date.
Excel functions can do it, of course. Power Query can do it too. Why Power Query then? Because we don't have to write a single formula (in most cases). In this video, I will show you the common date calculations offered by the UI of Power Query Editor.
I hope you like this video. If you do, please give a thumb up, leave a comment, share and subscribe. 😉
00:00 Intro
01:50 Calculate Age
04:05 Year related
06:00 Month related
07:14 Quarter related
07:39 Week related
12:17 Day related
15:06 Subtract two dates
15:35 Earliest and Latest
17:20 More Date Functions (when you are ready)
You may download a sample file from my blogpost to follow along:
https://wmfexcel.com/2022/11/19/basic...
#excel
#powerquery
#datefunction
На этой странице сайта вы можете посмотреть видео онлайн Power Query Basic 12 - Basic Date Calculations длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь wmfexcel 12 Ноябрь 2022, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 1,169 раз и оно понравилось 12 зрителям. Приятного просмотра!
