In this article, we have explained how to create an employee-wise skill set list using FILTER and TEXTJOIN Functions. We have explained another tip using the CONCATENATEX function in DAX. We have used Power Pivot to create this.
We have below data in the Excel table:
We have used the below function to get the unique employee in ascending order:
We have used the below formula to get the employee-wise skill set list:
=TEXTJOIN(", ",TRUE,SORT(FILTER(Table1[Skill Set],Table1[Name]='Tip1'!B5),1))
We have added the table to the data model and loaded it as a Power Pivot. We have created a DAX measure as given below:
=CONCATENATEX(Table1,Table1[Skill Set],", ",Table1[Skill Set],ASC)