Power Query Editor
In this course, we will learn, about the Power Query Editor, click on any card topic of your choice and start learning.
Happy Learning!
Data Transformation
We can use the Replace Values feature in Power Query Editor to replace any value with another value in a selected column.
The transpose table operation in Power Query rotates our table 90 degrees, turning our rows into columns and our columns into rows.
In this exercise, we will learn about splitting the column in Power Query Editor.
In this exercise, we will learn about Duplicate Column in Power Query Editor.
In this exercise, we will learn about removing the row, counting the rows and reversing the rows in the power query editor.
In this exercise, we will learn about merging, removing, renaming the columns. Also Choose and Go to Columns use in the Power Query editor.
In this exercise, we will learn about creating a Conditional Column in Power BI.
In this exercise, we will learn about Standard Function in Power BI.
In this exercise, we will learn about the Promote and Demote Headers in Power BI.
In this exercise, we will learn about Index column in Power BI.
Query Management
In this exercise, we will learn about renaming the query in the Power Query Editor.
In this exercise, we will learn about deleting a table (query) from Power BI.
In this exercise, we will learn about Duplicating the table (query) in Power BI.
In this exercise, we will learn about Organize Queries into Groups in Power Query Editor.
In this exercise, we will learn about Creating and Managing Parameters in Power Query Editor.