Forum Discussion
Solved
undefined
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
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.Thanksthis is the error
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
