Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
@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:
this is the error
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |