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-calendar/ 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_confirmation=1 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: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #445 #fiscalcalendar #powerquery #m