Date Formats in Power Query
Date formats in Power Query are one of those little issues that drives me nuts… you have a query of different information in Power Query, at least one of the columns of which is a date. But when you complete
Date formats in Power Query are one of those little issues that drives me nuts… you have a query of different information in Power Query, at least one of the columns of which is a date. But when you complete
Tonight I decided to actually follow through on something I’d been musing about for a while: building a full fledged VLOOKUP function in Power Query. Why? Yeah… that’s probably a good question! Replicating VLOOKUP’s exact match is REALLY easy in
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
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.