One of the things I really like to do with Power Query is shape data into optimized tables. In order to accomplish that goal, I’ve begun using Power Query to source data over Power Pivot’s built in methods. But in
Earlier this week I received an email asking for help with a Power Pivot model. The issue was that the individual had built a model, and wanted to add slicers for value fields. In other words, they’d built the DAX
For the first post of the new year, I thought I’d tackle an interesting problem; how to Transpose Stacked Tables in Power Query. What’s do I mean by Stacked Tables? It’s when your data looks like this: Notice that we’ve
A couple of weeks back, I received a comment on my “Force Power Query to Import as a Text File” blog post. Rudi mentioned that he’d really like to see a method that would let us Treat Consecutive Delimiters as One;
We're back with post two of Miguel's week. This time, he is going to take his previous solution and show us how versatile Power Query can be, leveraging code he's already written and Making Transformations Re-Usable. Have at it, Miguel! Making Transformations Re-Usable In
This week we've got a guest post from Miguel Escobar, who is going to tell us why transforming data with Power Query is his first preference versus other tools and methods. In fact, this is part 1 of 2, and
I’ve run into this issue in the past, and also got an email about this issue this past week as well, so I figured it’s worth taking a look. Power Query takes certain liberties when importing a file, assuming it
One of the things that I’ve complained about in the past is that there is no built-in way for Power Query to be able to pull up the path for the current workbook. Today I’m going to show you how
In last week’s post we looked at how to combine multiple files together using Power Query. This week we’re going to stay within the same workbook, and combine multiple worksheets using Power Query. Background Scenario Let’s consider a case where
This post illustrates a cool technique that I learned at the MVP summit last week, allowing us to use Power Query to merge multiple files with properties from the file in the output. A specific example of where this is useful is
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
