Get Your Name in M is for Data Monkey
I’m pleased to say that our new book “M is for Data Monkey” is now complete, through the technical edit, and into the copy edit stage. While there is still more work to go, the book is on schedule for
I’m pleased to say that our new book “M is for Data Monkey” is now complete, through the technical edit, and into the copy edit stage. While there is still more work to go, the book is on schedule for
A couple of weeks ago, Rudi asked how you would go about setting up a query to remove all rows up to a specific value. Specifically, his question was this: The other day I was asked if Power Query could
I was teaching a course on Power Query yesterday in which we imported a text file. Almost immediately, some of my users pointed out that their dates weren’t importing correctly, and we had to cover how to fix date errors
If you’ve been using my fnGetParameter function to build dynamic content into your queries, you may have noticed that passing some variables recently started triggering an error message that reads as follows: We couldn’t refresh the connection ‘Power Query –
I know this topic has been covered before, but I’m teaching a course on Power Pivot tomorrow, and it’s something that I’ll probably be brining up. As we need a calendar table for our Power Pivot solutions, a method to
Power Query is all about transforming and filtering data, and automating the process. One of the tedious tasks that accountants get to deal with all the time is bank reconciliations, which is essentially the process of filtering and matching items
Chandoo posted an interesting challenge on his blog last Friday, challenging users to calculated hours worked for an employee name Billy. This example resonated with me for a couple of reasons. The first is that I’ve had to do this
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
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.