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
Sur cette page du site, vous pouvez voir la vidéo en ligne Power Query Basic 12 - Basic Date Calculations durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur wmfexcel 12 novembre 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,169 fois et il a aimé 12 téléspectateurs. Bon visionnage!
