4 Ways to Create Date Column for a Calendar in Power Query

This videos shows 4 ways to create date series out of thin air in Power Query. Any of these works as robust first step for a date table.

WRITTEN BLOGPOST:
https://gorilla.bi/power-query/date-t...

Master Functions and Syntax in M
https://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: https://paypal.me/rickmaurinus.

Website: https://gorilla.bi

SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...

LET'S CONNECT:
Blog: https://gorilla.bi
Facebook:   / bigorilla  
Twitter:   / rickmaurinus  
LinkedIn:   / rickmaurinus  

Thank you for your support!

00:00 Introduction
00:50 Using Autofill within List
03:49 Function: List.Numbers
07:11 Function: List.Dates
09:15 Function: List.Generate

#calendar #dates #powerquery