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

[@abimaelesauaguilarvalerian4177]

Thank you so much. A lot of value in this video!!!

[@RafaelRomero-o7r]

Awesome, I'm getting pro each day in Power Query by watching your videos and of course because of you!, thank you so much, greetings from dominican Republic.🎉

[@darwinposo]

Quality Content. Clear , Concise and Comprehensive. Keep it coming....

[@IIIUMINAT1I]

This guy. What a hero

[@BIGorilla]

And what would I be without supporters. You are the real hero Max. Amen 🙏

[@roycemekolle7334]

This is my favorite Power Query content channel. Please keep sharing these awesome contents

[@BIGorilla]

That’s very kind, thank you🙌

[@SndfOmar]

Awesome Date info. Thanks a lot for sharing. 5 Stars!

[@Rockmans1989]

Thank you so much for this video! You're the best!

[@aytunch]

Great tutorials, keep more coming Rick

[@BIGorilla]

Thanks aytunch. 🙏 keep monitoring, more coming next week!

[@mnowako]

Awesome! The content and quality of all your videos is second to none! I look forward to more of your videos. Great lessons. Thank you! 👏

[@BIGorilla]

Thanks Mariusz, happy to help! I find the more we share, the more we all learn. And there’s a lot of areas that can use more content. Have you ever considered making content?

[@kamaur01]

This was helpful. Thank you

[@ritsasemprou3888]

thank you for sharing!!!!!!!!!!!!!!!!!!! waiting for part 2 :)

[@BIGorilla]

Coming next week Dec 22nd!

[@naylord5]

Your content is amazing! Thank you so much for sharing! New subscriber.

[@BIGorilla]

🙏 Thanks Luis, it's so nice to hear you like the content. Thanks for leaving a comment. There's more coming soon!!

[@eriks.9239]

This is great context, with simple explanations. Is it possible to link the value of the variables to a lower and upper value of another table containing transactional data?

[@CAKimberlyLewis]

Good stuff! Thank you!!!

[@williamarthur4801]

Really good, it must be it's my third time of watching, mainly for the list.generate. If I had a question, it would be regarding the use of the underscore , and when and why it is needed after 'each' but not always. Perhaps a future video, I don't think it's been done.

[@BIGorilla]

The underscore is short for a function: The m language has some short syntaxes that do the same. They allow you to perform an operation on each underlying value. Equivalent are : Each _ Each () => _ Each (x)=> x The version in the video is a short way to write it. To make life easier :)

[@williamarthur4801]

@@BIGorilla Thanks, I did quite bit of experimentation after watching your 'generate' video, using each _ , List.Generate( () => 1, (_)=> _ < 7, (_)=> _ + 1 ) List.Generate( () => 1, (A)=> A < 7 , (A)=> A + 1 ) What I found interesting was that the 'initial function could not be named, I first tried to use the _ or 'A' within that as well. Richard.

[@aydeediaz2307]

Hi! Very good video! What if I want to create a column in an excising table? referencing the column "source" so it will take the date from de SP

[@lavanyavijay6456]

That's awesome. But how to generate dates between 2 date intervals of same date column? i have a date column 11/11/2021 and in second row its 1/3/2022 how to fill the dates between these 2 dates?

[@augustocesardasilvacrisost4331]

Hi! I have a doubt. Instead of using a parameter, how do I reference the StartDate and the EndDate that is already in a columm inside a table?

[@BIGorilla]

Would there be multiple dates? And do you want multiple calendars?