Microsoft quietly changed something in Power Query and it genuinely caught me off guard. In this video, I explain a recent change to how custom columns are edited.
Although the issue relates to Excel for Mac the video is still worth watching.
Functionality in the Power Query Editor is increasingly being aligned across platforms, including Excel for Web and what appears first on Mac or Excel Online often makes its way to Windows
If you rely on Power Query to clean, shape, or transform data, this is one of those small changes that can have a big impact on your workflow.
Download a copy of the file(s) used in this video: