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?
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?
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.🎉
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?
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.
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 :)
@@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.
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?
Good stuff! Thank you!!!
Thank you so much. A lot of value in this video!!!
This guy. What a hero
And what would I be without supporters. You are the real hero Max. Amen 🙏
Great tutorials, keep more coming Rick
Thanks aytunch. 🙏 keep monitoring, more coming next week!
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?
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.🎉
Your content is amazing! Thank you so much for sharing! New subscriber.
🙏 Thanks Luis, it's so nice to hear you like the content. Thanks for leaving a comment. There's more coming soon!!
Quality Content. Clear , Concise and Comprehensive.
Keep it coming....
Awesome Date info. Thanks a lot for sharing. 5 Stars!
Thank you so much for this video! You're the best!
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?
Would there be multiple dates? And do you want multiple calendars?
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
This was helpful. Thank you
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! 👏
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?
This is my favorite Power Query content channel. Please keep sharing these awesome contents
That’s very kind, thank you🙌
thank you for sharing!!!!!!!!!!!!!!!!!!! waiting for part 2 :)
Coming next week Dec 22nd!
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.
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 :)
@@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.