Reduce Development Lag
How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue. I thought it might be a good idea
How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue. I thought it might be a good idea
Today a user brought up something in the forums I've seen before; adding null to values returns null. Simply put, they wanted to add the values in two columns together, but didn't get the results they expected. The issue: Adding
How you protect power queries is a question that will come up after you've built a solution that relies heavily on Power Query, especially if you're going to release it to other users. (This is a quick post, as I'm
I knew that the create Column From Examples feature had been released to Power BI Desktop, but it just showed up in my Excel 2016 build today. And man is it cool! A scenario for Create Column From Examples A
Last week I announced that we are working on a series of free 'DIY BI' e-Books. We've been hard at work on polishing it up, and I'm pleased to announce that the first DIY BI e-Book launches tomorrow! It will
Today I wanted to just make a quick announcement that we are currently working on a series of free 'DIY BI' e-Books. Free 'DIY BI' e-Books? Tell me more! Over the past few years of working with Excel an Power
I got an email from a reader this morning who asked how to calculate start and end dates for a given employee when they have had multiple terms of employment. Since it's been a while since we've had a technical
This week's blog post on using Power BI when you're not a data person is a guest post by Rebekah Sax of Excelguru Consulting Inc. Last week I participated Excelguru's first ever "Data to Dashboards" Power BI Boot Camp. Seventeen of us lucky
This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski Does your business or work group have manual tasks that are repeated regularly, such as data re-entry, copy/paste functions, sending the same old email,
(Please note that this blog post is from 2017, so the dates included below were for our very first boot camp. For dates and information on current sessions, please visit http://xlguru.ca/data2dashboards.) I'm pretty excited to announce that we have our
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.