Why Every Finance Professional Should Learn Power BI (not just Excel)
Discover how Power BI helps Finance professionals automate reports, boost efficiency and uncover deeper business insights beyond Excel
Category PowerQuery
How does Power BI solve the Multiple Datasets problem?
How does Power BI solve the Multiple Datasets problem? When we need to complete a task in Excel, it is sadly rare that all the information that we need is all held in one dataset. We often need to get…
Power BI Solves – The Data Transformation Problem
The Data Transformation Problem The first in our series of Power BI Solves, a collection of articles demonstrating common business issues that Power BI can solve (of which a fuller list can be found here), this article covers the Data…
What is Power BI and How Does It Work?
What is Power BI and How Does It Work? So the big question then…what is Power BI? That’s what we’re answering in this article, so that you can start to understand what it does and how it works and why…
How to fix a merge in Power Query
Why Is My Power BI Merge Not Working? Merging in Power Query, whether in Excel or Power BI, is one of the core skills for your average data transformationalist (is that a word?!) In essence, the purpose of a merge…
How to VLOOKUP Multiple Matching Rows Using PowerQuery
How to VLOOKUP Multiple Matching Rows Using Power Query? VLOOKUPS (and XLOOKUPS!) are a great function in Excel but they cannot be used to find multiple matching rows in a Lookup table. VLOOKUPS only return the first matching row that…
How to Connect PowerQuery in Power BI or Excel to a Sharepoint file
How to Connect Power Query in Power BI or Excel to a Sharepoint file. Being able to connect Power BI or Power Query in Excel to files on Sharepoint is a really useful skill. While connecting to files on OneDrive…
You must be logged in to post a comment.