Creating a Monthly Date Table in Power Query M

[@WAIT4GOD]

Awesome, thanks for taking the time to do this!

[@zahoorsarbandi2982]

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

[@BIGorilla]

Read the blogpost here: gorilla.bi/power-query/date-table-with-monthly-increments/ And for more on Functions and Syntax in M, check out: powerquery.how Enjoy!

[@GeertDelmulle]

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

[@BIGorilla]

Awesome, thanks Geert. Good stuff! List.Generate is the hidden gem in Power Query. You can use it for a lot. And it’s not too difficult once you know it’s basics ❤

[@GeertDelmulle]

@@BIGorilla Wees gerust, Rick, Ik weet het. :-) We vinden echter niet veel videos (use cases) die die functie gebruiken. List.Accumulate daarentegen: des te meer. Maar “Generate” is heel krachtig en jij hebt dat heel duidelijk en heel efficiënt gedemonstreerd. Jouw kanaal is het échte Hidden Gem hier: een compliment dat je méér dan verdient en dat ik eens in jouw eigen taal wou zeggen. (Zij het met een Vlaams accent, maar toch ;-)

[@BIGorilla]

​@@GeertDelmulle Heerlijk dit. Nederlands, Engels, Spaans. Het is allemaal welkom op dit kanaal. En wat een mooi compliment, dank je daarvoor. Het is ook leuk dat er telkens weer nieuwe use-cases handig zijn. More is coming. Tot bij de volgende video?

[@GeertDelmulle]

@@BIGorilla “Tot de volgende video?” - are you kidding me? I’m a sub for a long time now and the bell will ring on your next video, so: Yes, I wouldn’t want to miss it! 😃

[@MrUmbeijo]

Thank you for the helpful video!

[@BIGorilla]

Glad to help. Hope you learned something new. For what have you been using list.generate so far?

[@NearbyCactus]

I love the way you explain this stuff!

[@PowerBIPark]

I keep coming back to this one :)

[@carlo_migliari81]

More video please! Ciao!

[@BIGorilla]

Thanks Carlo! more coming for sure :)

[@mirrrvelll5164]

Good one!

[@MrSpiritUAll]

Duidelijk uiteengezet! 👍

[@BIGorilla]

Bedankt!

[@anupamsachan]

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

[@rafiullah-zz1lf]

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

[@jimgleason4040]

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.

[@BIGorilla]

Hey Jim, You can only do that by changing the step names in the advanced editor. Cheers Rick

[@williamarthur4801]

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.

[@abhishekawari919]

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

[@christopherregalado3029]

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!

[@tranquilsleeprelaxationstu9078]

This was helpful kzbin.info/www/bejne/pISWc5qvbZ2XmZo

[@viks881]

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

[@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. kzbin.info/www/bejne/ipm3aYqghKuZo5o