Tag: power query advanced editor

Power BI Custom Query Functions

Power BI Custom Query Functions

For today’s tutorial, we’re going to build a Power BI custom Query function that’s going to deal with a common difficult-to-handle format of stacked data. This technique is easily reusable on multiple reports and multiple tables. You can watch the full video of this tutorial at the bottom of this blog. This is a continuation

Continue reading

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

Query Editor In Power BI | An Overview

WHAT'S POSSIBLE WITH THE QUERY EDITOR

In this tutorial, we’ll show a detailed example of why we always need to use the Query Editor in Power BI and what we can achieve when using it.  It’s deemed a best practice to always bring your data into the Query Editor first. We’ll show and prove it by running through some examples and

Continue reading

Table Value – A Common Structured Value In Power BI

Table Value - A Common Structured Value In Power BI

This tutorial will discuss about table value. It’s one of the most common structured values that you can encounter in many Power BI data reports. You’ll learn how to build tables using different expressions in order to obtain specific information and make your report insightful. Creating A Table Value Think of tables as a list

Continue reading

Power BI Power Query: Removing Duplicate Rows

In this blog, I’ll show you how to remove duplicate rows in the Power BI Power Query based on conditions. You may watch the full video of this tutorial at the bottom of this blog. This example is from a question that was raised on the Enterprise DNA Forum. The member has transactional data and

Continue reading