Power BI Power Query Tutorial Table.Unpivot, Table.UnpivotOtherColumns

Описание

In this video, we will explore two Power Query functions in Power BI: Table.Unpivot and Table.UnpivotOtherColumns. These functions are used to transform a table by rotating its columns into rows, a process called "unpivoting." We will explain how to use these functions with examples and discuss their benefits. Expert-level techniques are showcased in this series and help in mastering Power BI and PL 300.#powerbipro #powerquery #dax #learnpowerbi #amitchandakda

▶️Please Subscribe: https://www.youtube.com/@AmitChandak
▶️Get The data and Pbix files on Github: https://github.com/amitchandakpbi/powerbi/tree/main/Data%20for%20Learn%20Power%20BI%20Full%20Video

▶️ Here is the timestamp of all the topics I have discussed in this tutorial:
00:00 Introduction, Basic Concepts
02:30 Power BI Table.Unpivot
07:30 Table.UnpivotOtherColumns

First, we will cover the Table.Unpivot function, which converts columns into rows by creating two new columns: Attribute and Value. We will demonstrate how to use this function with an example of a table with columns for Sales Region, Q1 Sales, Q2 Sales, Q3 Sales, and Q4 Sales. By using Table.Unpivot, we will transform this table into a new table with columns for Sales Region, Quarter, and Sales, where each row represents a quarter's sales for a particular region.

Next, we will explore the Table.UnpivotOtherColumns function, which is similar to Table.Unpivot but allows you to choose which columns to keep as-is. We will explain how to use this function with an example of a table with columns for Sales Region, Product Type, Q1 Sales, Q2 Sales, Q3 Sales, and Q4 Sales. By using Table.UnpivotOtherColumns, we will transform this table into a new table with columns for Sales Region, Product Type, Quarter, and Sales, where only the sales columns are pivoted into rows.

Finally, we will discuss the benefits of using these functions in Power BI. We will explain how these functions can help you transform and shape data from different sources, and provide a way to organize data for further analysis and visualization. These functions can help you manipulate data that is not in the desired format and provide a more efficient way to work with data in Power BI.

By the end of this video, you will have a good understanding of how to use Table.Unpivot and Table.UnpivotOtherColumns functions in Power BI, and how they can help you with your data analysis and visualization needs.

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
https://www.youtube.com/watch?v=cN8AO3_vmlY
-~-~~-~~~-~~-~-