So this is just huge, especially if you work with Power Pivot models and are stuck in 32 bit Excel… Microsoft has just released a 32 bit Excel Memory Limit increase for users of Excel 2016, effective build 16.0.6868.2060 (which
Ken is at the PASS BA conference this week, so it seemed like a perfect time for me to publish my first Power Query post here. In this installment, I'm going to show how to map columns between data sets.
One of the questions I get quite frequently is how we can pass parameters to SQL queries, allowing us to make them dynamic. Someone asked a question in the forum on the topic, so that finally inspired me to write
Well, there’s good news and bad this time. I just updated my Excel 2016 to 16.0.6868.2048 (First release version) and there is a fix and a new bug evident. First, the fix As I reported a couple of weeks ago,
Hey everyone, we need your votes to make a difference in Power Query and Power Pivot! There are a couple of items in the uservoice forums that I’d like to bring your attention to, and hopefully entice you to vote
The April 2016 Power Query Update was just released for Office 365 subscribers, and I can confirm that it is available to the First Release customers, as I’ve already got it installed. (If you’re on a later branch it may
I got an email from a friend today who was using some complicated logic to replace specific records in a table with records from another table. His query was running pretty slow, so he reached out for a little help.
A while back I got an email from someone who had taken my Power Query course online. They were asking how to create a running total, although with some added twists and turns for calculating taxable gains and losses for
I got a question on the blog recently about creating a banding function in Power Query, or creating buckets for Accounts Receivable transactions (30-60 days, 60-90 days, etc.). As this is something that can be applied to a lot of
I was a bit surprised to see some Excel 2016 updates when I opened it up this morning. For reference, I am on an Office 365 early release program – so I might get these a bit before you do
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
