Fun trick to Remove the Promoted Headers Step in #PowerQuery
#Mjoy
goodly.co.in/learn-m-powerq…

Advanced Text Trimming with Lists in #PowerQuery
Mjoy

#PowerQuery 's Text.Range function is slightly more capable than the MID function in #Excel . 💡

You can specify the initial offset count (characters to skip) and it magically returns the rest. ✔️

(M)Joy!

Have you used Table Schema in #PowerQuery before, I think it is awesome.
#Mjoy
goodly.co.in/learn-m-powerq…

Here is how you can do some weird things in #PowerQuery .
#MJoy

A client asked how to merge files with different column headers in #PowerQuery . The issue she's facing is that some of the files in her folder have a column called 'customer', where others have a column called 'ship to/customer'. 
👍 Here's what we did: excelguru.ca/merge-files-di…

Two new #PowerQuery join kinds added in March 2024: JoinKind.LeftSemi and JoinKind.RightSemi. They can make some joins more efficient:

Not sure why anyone would want to unpivot data without using PowerQuery....

But here is how to do it using Shortcut Alt D P
...............
Follow for more tips
...............
#Excel #DataAnalytics #spreadsheet

The M function Module.Version is now available on the #excel beta channel.

This function allows you to easily retrieve the current version of your #powerquery instance. What's great about that is that you can add this information to the output of your queries.

現在学習はPower automate、PowerBI、PowerQueryに集中してます

今の会社の情勢を考えるとたぶんこれが正解、自分の嗅覚を信じます

英語学習は0にはしないけれど金フレとでる1000を隙間にやるくらいかな

₍ ˄ ·͈ ·̫ ·͈˄₎ 社内サバイバルだね

チルさんは飽きるの早いね

Data nerds, any powerquery editing tips???

It's been a while.

One of the many features I enjoy with PowerQuery Editor is this part, where all the steps you've taken can be seen

Good morning 🤍
Another week to smash all your goals

With #PowerQuery being available for #PowerBI Paginated reports in Report Builder, you can now do something that was very hard to do in the past. Patrick shows you what's new!

Watch on YouTube - guyinacu.be/pqinpaginated

Releasing Soon!
Modern Data Analytics in Excel By George Mount 
It serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics.
Pre-order now
shroffpublishers.com/books/97893554…
#excel #powerquery #powerpivot #businessanalytics
#dataanalytics

Using #PowerQuery here is a simple count of how many Betfair Historic Win & Place files are available for each Country
promo.betfair.com/betfairsp/pric…
I've removed those at the start of 2008 as their naming convention was different compared to present formatting.
53,000+ files 😉👍😉

5 years ago today, I delivered a full-day workshop on #PowerBI #Architecture at #IntelligentCloudCPH #Copenhagen
I am returning to Copenhagen after five years this time. I will be delivering a #PowerQuery #DeepDive workshop at #PowerBI NextStep on the 12th of September, followed…

I have just deployed M to #PySpark cheatsheet to the DataMeerkat website.

Besides separate pages, you can find a complete PDF here.

Link: datameerkat.com/cheatsheets/

#PowerQuery #MicrosoftFabric

#PowerQuery でグループ内で追番を附番できることを発見。これが出来るとパワクで出来ることがまた一段と増えて #VBA を書く量が減りそう。

会計検査院のデジタル人材募集、仕事内容がPowerQuery、VBA、PowerApps、PowerAutomate。これだけだとあんまりDX感ないですね。

iiajapan.com/leg/info/jobma…