Tag: Power Query Tutorial

Adding Data In Power BI | A Power Query Tutorial

As we know, data has a lot of different forms before we can retrieve and bring it in Power BI. Power Query offers several advantages when it comes to importing and consolidating Power BI data. In this blog, we’ll discuss the different ways on how we can bring data in Power BI. Think of Power

Continue reading

Comparing Tables In Power Query | Power BI Tutorial

Comparing Tables In Power Query | Power BI Tutorial

Comparing tables is a very common task in Excel and can get tedious if you do it manually all throughout. In this tutorial, I’ll show how you can easily compare two tables in Power Query to isolate the items that do not appear on both tables and report the differences. You can watch the full

Continue reading

Using Power Query Advanced Editor To Extract Values Before A Specific Text

Using Power Query Advanced Editor To Extract Values Before A Specific Text

For this tutorial, I’m going to demonstrate how you can extract values before each occurrence of a specific text using Power Query Advanced Editor. There are many ways to achieve this, but I thought it would be fun to show a solution that’s fully coded. You can watch the full video of this tutorial at

Continue reading

Power Query Function In Power BI: Group By Function

Power Query Function In Power BI: Group By Function

This tutorial is about a power query function in Power BI called Group By. It’s an underrated feature in Power BI that lets you solve common problems in the simplest way possible. You can watch the full video of this tutorial at the bottom of this blog. Group By function is the best option when you have

Continue reading

Power BI Unpivot Columns – Power Query Tutorial

This is a tutorial about Power BI unpivot columns. I’m going to show you how to unpivot multiple column combinations. You may watch the full video of this tutorial at the bottom of this blog. This is part of an unpivot variation series, which is all about turning your data into a proper tabular format

Continue reading