Forum Discussion
Eng-mohd
Helper I
Helper Iundefined
Combine two columns
Data like in pic
Desire column
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
3 Replies
- DallasBaba
Skilled Sharer
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-mohdthis is the error
- DallasBaba
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