Create a Dynamic Calendar Table
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
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
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
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