In this post, I will discuss how to create a range in the power query editor. What's the use of knowing that? Assume you've been given a database to analyse that is updated on a regular basis, and you haven't had any communication with the data entry person. It's a waste of time and effort to keep copying and pasting data and adding new columns and formatting, but the power query editor can turn you into a star.
Let's get started. Follow the steps to create a range without messing with the actual data.
In this situation, I have data of student Id and their scores. I want to create an "A-D" grade system. Now I have 2 options one to use IF function in excel by inserting a new column and another using a power query editor.
Go to the DATA tab
Upload file through GET DATA
On Navigator tab select TRANSFORM database
Then select ADD COLUMN tab
Go to CONDITIONAL COLUMN
Write the given situation and press OK
Finally CLOSE & LOAD your data
Following these 7 steps will create a customized column in your database for further analysis and editing.
Please check this video to know more in detail.
Comentários