Creating a Monthly Date Table in Power Query M

How can you create a date table with monthly intervals? This technique achieves it with ease.

WRITTEN ARTICLE

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#DateTable #powerquery #bigorilla

[zahoorsarbandi]

Explanation is fantastic. even a complected topic seems very easy..

[GeertDelmulle]

Now that is nice and clean!
Good stuff and very powerful.
Thanks for the video! :-)

[anupamsachan]

@bigorilla very use video pls create more to tech such a wonder full learning🥇🥇🥇🥇

[NearbyCactus]

I love the way you explain this stuff!

[rafiullah-zzlf]

I have yearly data i can do group by which will filter and calculate sum or any other valies i want but the thing is i want to insert that groupby for each month end .. can you do a video

[jimgleason]

Absolutely Cool. You always seem to tackle issues in a systematic way. One question. How do I change the name from "Source" in the Query to Today? When I try the Rename Step it is not available. Although it is just cosmetic would like to know.

[williamarthur]

One thing, when you changed the the null value? I've never really understood what a lot these do,
so I tend to add the splitter.spiltbynothing() and leave it at that, yes I've read the docs, but never quite sure what it all means, eg ; optional splitter as nullable function ? Perhaps an intro to some of the language used. I've become a great fan of List.Generate thanks to your work.

[viks]

I am getting error of We cannot apply field access to the type date. Can anyone help..?

[christopherregalado]

Hi Rick, how can I create a monthly total and have it inserted as a new row at the end of the month and have the days in the month auto grouped. For example, I have 500 days/rows of data for about 17 months. and I'd like each day to show and be grouped by month (Jan 1-31 one group, Feb 1- 28, and so on) and a new row added with the monthly total. Jan total, Feb, etc... Thank you for any video links that you may have already explained this!

[abhishekawari]

Hey how we can achieve this using measure in powerbi? Can you pleas make video on this monthly date calender

[josh_excel]

This was my first time seeing " type table" used, so I created a video for other ways to use it when creating a table. Sadly, it doesn't change text to the specified data type like a normal Changed Data Type step does.