Hi Nithin,
1. Go to Power Query Editor, after selecting required sheets from data source.Click on Add Column tab.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=6512080771758489251)
2. Now you can create a new column using conditional column or custom column.
- Custom column allows user definition of creating columns by using formula.
- Conditional column allows user a column based on if else conditions.
3. Using Custom Column. (click on Custom Column, the below dialog box opens)
![](https://www.edureka.co/community/?qa=blob&qa_blobid=15082778141612895930)
Enter column name, write formula using the fields required for calculation which are seen on the right of screen, and click on ok.
The new column is created as below.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=3634241867919634761)
4. Using Conditional Column. (click on Conditional Column option, the below dialog box opens )
![](https://www.edureka.co/community/?qa=blob&qa_blobid=13731473483995476498)
Enter column name, and write the conditions based on which column values are to be created (The values can be string or numeric or a field value ) and click on Ok.
The new field is created as below.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=2791786272569847701)
Hope this helps you.