Creating a 445 Calendar in Power Query M
Learn how to create a 445 calendar in Power Query M. This video covers setting up date columns, creating week, period, quarter and year indexes, and customizing for 445, 454, and 544 calendar variations.
WRITTEN ARTICLE:
https://gorilla.bi/power-query/445-ca...
I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
TIMESTAMPS
00:00 Introduction
00:33 Characteristics of 445 calendar
01:19 Fundamental Variables
01:49 Creating a Date Column
02:23 Starting Date of 445 Calendar
02:51 Creating Indexes
05:30 Flexible Period Index
10:55 Creating a Year / Quarter / Week column
12:33 Overview of important columns
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#445 #fiscalcalendar #powerquery #m