This complete guide teaches you how to create a date table. You will find the easiest way to create a calendar, learn how to add the most important columns and find a trick that saves you a lot of time in creating columns. And the best thing? You only prepare this once and can reuse the same code again and again.
WRITTEN BLOGPOST:
gorilla.bi/power-query/date-t...
Master Functions and Syntax in M
powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: paypal.me/rickmaurinus.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
kzitem.info?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
Chapters:
00:00 Introduction
02:11 Create Essential Columns
03:34 Adding Custom Columns
04:53 Custom Formatting with Date.ToText
09:45 Adding Weekend vs Workingdays
MUSIC
Killing Time Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
creativecommons.org/licenses/b...
#Calendar #PowerQuery #BIGorilla
Негізгі бет Create Date Table or Calendar in Power Query M (Complete Guide)
Пікірлер: 52