how to combined skill with separe with (comma)

[krishna_murthy]

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 ??

[rohit1991]

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],
    ", "
)

[krishna_murthy]

@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

[rohit1991]

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: 

[Ronak_1312]

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

Thanks.
Ronak Mistry

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.