How to add a new column in a table in Power BI ?

In this story we will see how we can add a new column in Power BI. This happens frequently where you need an extra column which is derived from the existing columns in the table. This method comes handy in such cases.

In Power BI a new column is added based an existing column by writing simple DAX (Data Analysis Expressions) queries. This can be used to perform various operations like calculating profit, loss, combining texts etc.

I have created dummy dataset, imported it from Excel Workbook to demonstrate the task.

Go to data tab and select new column. Here , I have added new column ‘profit’.

Query : Profit = [SalesAmount] - [ProductCost]

Concatenating two columns to create a new column. Here, I am concatenating ‘CustomerId’ and ‘CustomerName’.

Query :
CustId_Name = CONCATENATE('CustomerDetails'[CustomerId], CONCATENATE("_",'CustomerDetails'[CustomerName]))
OR 
CustId_Name = [CustomerId] & "_" & [CustomerName]

Resources :

1. Add a custom column in Power BI Desktop — Power BI | Microsoft Docs
2. How to Create a Calculated Column in Power BI (Step-by-Step) (spreadsheeto.com)

Hope you find this helpful!!

I will sharing more on Power BI.

Thanks :)