Love your style. This is just personal preference but; you added [Months]{0} to your M code in your main Table1 query, would it have been easier to right-click on Row{0} then "drill down", which would omit the need for that additional M code in your Table1 query. I tend to "Define name" the cells in an Excel worksheet and use that as your query reference.
Right click on cell in Excel, then 'Define Name' and give it a name. Right click on the cell and 'Get data from Table/Range' (your query will be named as the Defined Name) In the PQ Editor, right click on the row (which is your text on row {0}), then 'Drill Down' You can reference this query in your M code in other queries. I do this for text, numbers, dates etc. I also create Tables in Excel and when brought into the Editor, right click the whole column and 'Drill Down'. As an example, I do this for a list should I want to do a 'Filter' but for multiple words/criteria etc. It's such an effective way of exploiting this capability.🙂
Loving the new data lair...
Pro tutorials. Excellent explanation. Thanks for being so good. Merry Christmas.
so awesome thanks man! Happy new year there!
@basensei8699 Happy New Year!!!
Thank you very much. Not sure why it took me this long to see your channel. Love your content. subcribed.
Awesome, thank you!
Great one👍
glorious!
great as always ❤
thanks man!
Trop fort !!!
glorious!
Love your style. This is just personal preference but; you added [Months]{0} to your M code in your main Table1 query, would it have been easier to right-click on Row{0} then "drill down", which would omit the need for that additional M code in your Table1 query. I tend to "Define name" the cells in an Excel worksheet and use that as your query reference.
this is a excellent tip! i'm gonna try it! this is what i love learning new ways to do things!
@basensei8699 please do try it, I do it a lot, almost every solution I build
@@paspuggie48 you can even do it in one line of code like this.
= Excel.CurrentWorkbook(){[Name="Table10"]}[Content]{0}[Months]
Right click on cell in Excel, then 'Define Name' and give it a name.
Right click on the cell and 'Get data from Table/Range' (your query will be named as the Defined Name)
In the PQ Editor, right click on the row (which is your text on row {0}), then 'Drill Down'
You can reference this query in your M code in other queries.
I do this for text, numbers, dates etc.
I also create Tables in Excel and when brought into the Editor, right click the whole column and 'Drill Down'.
As an example, I do this for a list should I want to do a 'Filter' but for multiple words/criteria etc.
It's such an effective way of exploiting this capability.🙂
The Worm!
What's the matter ?! I haven't Seen any demo from my favorite Senseï since too many days !!! Please 🙏🏼🙏🏼🙏🏼🙏🏼, Come back 😂
glorious! i recently moved into a new house and now i'm back in action again! whoop whooop!
@basensei8699 that's the reason why !!! 🏠... A great come back 🙏🏼👍🏼👍🏼👍🏼