Create Column From Examples
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
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
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,
In this post we will explore how to make the Sample Binary file path dynamic when combining files using the new Combine Binaries experience in Excel and Power BI Desktop. Sample Files If you'd like some sample data files to
If you've wanted to use Power Query to combine Excel files with a single click - like you could for TXT and CSV files - the feature is finally here*. The Combine Binaries feature has been re-written (as I discussed
One of the updates in the latest Excel 2016 Insider preview build is a new Combine Binaries experience for Power Query. This is both good and bad, and in this post we'll take a detailed look at both sides before
The November 2016 update is now out and it finally brings a way to view the Power Query dependencies viewer. While it’s been out in Power BI Desktop for a while, (as Matt posted about a while ago,) this is
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
