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
Nesta página do site você pode assistir ao vídeo on-line Power Query Basic 12 - Basic Date Calculations duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário wmfexcel 12 Novembro 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,169 vezes e gostou 12 espectadores. Boa visualização!
