Did you know that with Power Query in Office 365, you can create basic M Language code and functions? The recommended practice is to let Power Query generate the code. In some situations however, it might be interesting to add your own custom touch.
Πηγή: Power Query M Language | Office 365 content from SharePoint Pro
If your Excel cubefunctions shall return dynamic sets, like Top 10, then this is the easiest way to go:
Πηγή: Excel Cubefunctions: Trick for dynamic sets – The BIccountant
After an amazing first Power Query workshop in English, we are providing our attendees with even more CRAZY cool content that they’ll be able to put into practice (and understand) right away! You might have already seen an ABC Classification Pattern with Power Pivot here, but this time you’re going to see this pattern being …
RSS
SL Galaxy
Facebook
Google+
LinkedIn
Twitter
