topic Re: how to combined skill with separe with (comma) in DAX Commands and Tips

how to combined skill with separe with (comma)

krishna_murthy — Fri, 03 Oct 2025 10:05:10 GMT

Hi Team,,

Just want to check with you on the requirement we want to create below result

Real case question:-

Name Skill

Naveen SQL

Naveen Azure

Naveen Power bi

Srinivas MSBI

Srinivas SQL

Srinivas Power Bi

Final Result is ;-

Name skill

Naveen SQL,Azure,Power Bi

Srinivas MSBI,SQL,Power Bi

Please check and provide any feasible option on the DAX ??

Re: how to combined skill with separe with (comma)

rohit1991 — Fri, 03 Oct 2025 11:00:03 GMT

Hi krishna_murthy

I used a sample table named 'Sample Data' to solve your problem. You can replace it with your actual table name in the measure.

Sample Table:

Create Measure:

Combined Skills = CONCATENATEX ( VALUES ( 'Sample Data'[Skill] ), 'Sample Data'[Skill], ", " )

Re: how to combined skill with separe with (comma)

krishna_murthy — Fri, 03 Oct 2025 14:01:25 GMT

rohit1991 Thank you for your time.

Along with name and skill .. there are other columns also duplicates so how we can include and get the result.
this are the details

Full Name	Timezone	Location_of_Coder	Primary_Chart_Type	SecondaryChartType	TertiaryChartType	Skill
Arun Malik		Global
Arun Gokul		Global
Arun Gokul	US - Central	Domestic	Outpatient			Cardiology/Cath Lab
Arun Gokul	US - Central	Domestic	Outpatient			Charging
Arun Gokul	US - Central	Domestic	Outpatient			Interventional Radiology
Arun Gokul	US - Central	Domestic	Outpatient			Outpatient Surgery
Krishna Kumrar	IST - Mumbai	Global	Outpatient	Professional	Inpatient	Claim Edits
Krishna Kumrar	IST - Mumbai	Global	Outpatient	Professional	Inpatient	Emergency Department
Krishna Kumrar	IST - Mumbai	Global	Outpatient	Professional	Inpatient	Injection and Infusions
Krishna Kumrar	IST - Mumbai	Global	Outpatient	Professional	Inpatient	Nephrology
Krishna Kumrar	IST - Mumbai	Global	Outpatient	Professional	Inpatient	Ophthalmology
Kiran Royal	IST - Bangalore	Global	Professional
Manoj Raj	IST - Chennai	Global	Professional

Re: how to combined skill with separe with (comma)

Ronak_1312 — Sat, 04 Oct 2025 05:49:30 GMT

For Above mention table with multiple column, what is your desired output.
So i can provide fesible solution with accuracy.

Thanks.
Ronak Mistry

Re: how to combined skill with separe with (comma)

rohit1991 — Sat, 04 Oct 2025 13:32:54 GMT

Hi krishna_murthy

The same measure you already have will work no changes needed.

Combined Skills = CONCATENATEX ( VALUES ( 'Sample Data'[Skill] ), 'Sample Data'[Skill], ", " )

The only important point is what I added after:
In the visual, do not include the raw Skill column.
Keep only your other columns (Full Name, Timezone, Location, Chart Types, etc.) + this Combined Skills measure.

Sample Data View :

Outcome:

Re: how to combined skill with separe with (comma)

Anonymous — Tue, 07 Oct 2025 04:11:00 GMT

Hi krishna_murthy ,

Thanks for reaching out to the Microsoft fabric community forum.

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by rohit1991 . If you still require support, please let us know, we are happy to assist you.

Thank you.

Re: how to combined skill with separe with (comma)

Anonymous — Fri, 10 Oct 2025 04:15:12 GMT

Hi krishna_murthy ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

Re: how to combined skill with separe with (comma)

Anonymous — Mon, 13 Oct 2025 06:47:13 GMT

Hi krishna_murthy ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.