For some time it’s bothered me that we don’t have full parity between Excel and Power Query functions. In this post I’m going to look at four Excel text function equivalents, intended to allow an Excel user to just work
Jeff Weir published a post at DDOE last week on global names freaking out when a local name is encountered. It reminded me that I ran into something similar when I was testing text functions in Power Query a while
As I was working on one of the assignments for our upcoming Power Query training course, it occurred to me that I’ve never blogged about this feature: how to retrieve related tables in Power Query. Retrieve Related Tables in Access
A friend of mine emailed yesterday asking how to compare data from different time zones. With how good the UI is in Power Query, you’d think this would be easy. Unfortunately it’s a bit less than that, so I thought
I know that this topic has been covered before by others, but I think it’s still pretty valuable for a user to be able to figure out what Power Query functions exist, especially since they are often different than what
I’m really pleased to announce that a new project I’ve been working on is live: powerquery.training, a website that offers online Power Query training! About PowerQuery.Training PowerQuery.Training is a joint effort between Miguel Escobar (of PoweredSolutions.co) and myself: the two
One of the cool features in Excel 2013’s Power Query is being able to load to the Data Model (PowerPivot) directly. But Excel 2010 doesn’t appear to have this feature. Interestingly, you can still load Power Query directly to Power
In a comment on my Parameter Tables post, Talha asks why we get prompted with a Native Database Query message each time the value of the parameter used in a SQL query changes: I had a question. The value I
This was a great question that came up in my M is for Data Monkey session at the Amsterdam Excel summit: Can we use dynamic ranges in Power Query? If I recall correctly, this was asked by Gašper Kamenšek, after
How would you like to make your data famous? Or at least – how would you like a solution built for your own data using Power Query… for free? I have a couple of Power Query related things I’m working
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
