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

Подписаться 23 тыс.

Просмотров 21 тыс.

50% 1

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:
gorilla.bi/power-query/date-t...
Master Functions and Syntax in M
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: paypal.me/rickmaurinus.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
ru-vid.com?sub_con...
LET'S CONNECT:
Blog: 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

Опубликовано:

6 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@user-wq2ck3gf4y 7 месяцев назад

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 2 года назад

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

@IIIUMINAT1I 2 года назад

This guy. What a hero

@BIGorilla 2 года назад

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 3 месяца назад

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

@Rockmans1989 Год назад

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

@mnowako 2 года назад

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 2 года назад

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 10 месяцев назад

This was helpful. Thank you

@aytunch 2 года назад

Great tutorials, keep more coming Rick

@BIGorilla 2 года назад

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

@CAKimberlyLewis 2 года назад

Good stuff! Thank you!!!

@naylord5 2 года назад

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

@BIGorilla 2 года назад

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

@ritsasemprou3888 2 года назад

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

@BIGorilla 2 года назад

Coming next week Dec 22nd!

@eriks.9239 9 месяцев назад

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?

@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

@williamarthur4801 2 года назад

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 2 года назад

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 2 года назад

@@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.

@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?