undefined

[Eng-mohd]

Combine two columns

Data like in pic

Desire column

 

[DallasBaba · Accepted solution]

@Eng-mohd 

This is the Power BI Solution using DAX.

You can archive this in the Power Query editor.

 Duplicate the Columns you want to merge

1 - Select the two columns

2- Roght click & select Merge Columns OR use the Ribbon tab as shown in the below image

If this post helps, please consider Accepting it as the solution to help others find it more quickly. 

Thanks

[DallasBaba]

@Eng-mohd You can use this Dax for the new calculated column

Combined = TableName[No] & " " & TableName[Name]

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  

Note: 

If this post helps, please consider Accepting it as the solution to help others find it more quickly. 

Thanks

[Eng-mohd]

 this is the error