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
On this page of the site you can watch the video online Power Query Basic 12 - Basic Date Calculations with a duration of hours minute second in good quality, which was uploaded by the user wmfexcel 12 November 2022, share the link with friends and acquaintances, this video has already been watched 1,169 times on youtube and it was liked by 12 viewers. Enjoy your viewing!
