Tag: Unpivot Query Editor

How To Unpivot Columns In Power BI

How To Unpivot Columns in Power BI

In this tutorial, we’re going to learn how to unpivot columns in Power BI, and understand the importance of doing it inside our data models. When working on data inside Power BI, we generally want it to be in an unpivoted format. This is the most optimized way a table can be set up for

Continue reading

Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor

Turn Calendar Type Layout Into Tabular Format In Power BI Query Editor Tutorial

Analyzing the data that we have can be difficult if it is not correctly arranged. In this tutorial, I will explain how to transform vertical and horizontal repeated data into a tabular format. We do this so that we can have an easier time analyzing it using Power BI. This tutorial was made to address

Continue reading

Unpivot And Pivot Basics In Power BI – Query Editor Review

There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature in the Query Editor within your data queries. One thing to bear in mind early

Continue reading