In my last post, we looked at creating an IF statement using Power Query. This time we’re going to go a bit deeper and look at multi condition logic in Power Query, exploring a scenario where we need to choose between
In my last post I talked about useful text functions, and how they differed between Excel and Power Query. Today we’re going to look at another compare/contrast scenario, but this time it’s going to be the IF function in Power
Years ago I published an article on my site called Five Very Useful Functions For Working With Text. This post is alternative version, but with a twist. I bring you 5 Very Useful Text Formulas - Power Query Edition. The
My last two blog posts detailed some frustration that I ran into when working with Power Query. First the issue that I couldn’t trust folders, but got stuck trusting files, and then the issue where I overloaded my credentials area.
After my last post on Power Query Security Woes, Ehren – a developer on the Power Query team – sent me a message on Twitter about it. I will blog about that later, after I’ve had a chance to test
Recently I’ve been working on automating a business process for a client. It’s become a really interesting project that uses a mix of Excel tables, Power Query, Power Pivot and VBA, as well as a WinAutomation script. Before I talk
A couple of weeks ago I was teaching a course on Power Query. I distributed a bunch of sample files, started to walk the attendees through the steps, and a hand went up. “I get an error in my date
Some time ago I published a blog post about an add-in that I’m building, and the reasons why I elected to start using Add-In Express to manage the process. I still think Add-In Express is the best product for this
At our last MVP summit, I sat in on a session on PowerQuery. Our presenter, who is pretty passionate about it, at one point asked us “Who has wanted to use PowerQuery on their email inbox?” And honestly, I have
Several years ago, when Power Pivot first hit the scene, I was talking to a buddy of mine about it. The conversation went something like this: My Friend: “Ken, I’d love to use PowerPivot, but you don’t understand the database
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
