PowerBI Query Editor.md

PowerBI Query Editor

Ribbons present in the query editor. We need to Transform the data, create data model and visualize the data. Open the sales csv file and open the transform data. This will open a query editor for us to do the data cleaning. 1.File 2.Home 3.Transform 4.Add Column 5.View 6.Tools 7.Help

1) To remove the top/empty/blank rows in the data.`

Home-> Remove rows-> Remove Top Rows

Home-> Remove rows-> Remove Blank Rows

Home-> remove rows-> Remove duplicate

After removing the top 2 rows it will show in the applied steps to the right - This helps to keep track the changes made in the data). Also we can reconfigure the steps to make changes without removing the applied steps.

---

2) To make the first row into a header.

click that row-> Home-> Use First row as Headers

---

3) To change the data types from text to fixed decimal for revenue column.

Go to the column-> click the column name icon-> change to the fixed decimal

---

4) To extract a particular characters in the data

Transform-> Extract-> First Character-> Enter the count.

---

5) To split the columns

Home ->Split column->By position/By character/By delimiter

---

6) To remove the white spaces in the data - text Operations

Tranform-> Format-> Trim [OR] Right click on the column-> Transform-> Trim

TRIM - Will remove all tyhe leading and ending white spaces

Tranform-> Format-> Clean [OR] Right click on the column-> Transform-> Clean

CLEAN - Will remove any unwanted tabs or white spaces in between the texts.

---

7) To do numerical operations in the text - To change the column from cm to inch

Transform-> Number column

---

8) To create a relationship between two or more table, we have to create data model

Go to Model view-> Drag and drop the common column to the other table

Check the common column id present in both the tables. Just create a connection between the both using the model view.

---