Data Transformation to create Comma Separated List automatically | FILTER, TEXTJOIN and CONCATENATEX

#FilterFunction #DAXFunctions
Hello Friends,

In this video, you will learn 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.

Download the practice file from the below link:

Download the Free Project Management Dashboard


See our Power BI Dashboard videos:


Learn and download our interactive Excel dashboards free of cost-
Download the Calendar Control in VBA from below link

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Instagram:

Visit our Amazon Store

[miguelprietosanchez]

Excelent congratulations from Venezuela

[prasad]

thank your PK for new way. i used to do this in Power query through group by

[AjaySharma-emez]

god of excel has come once again with a new boon to all of us. Sir, Thank you very much, my hands touch your feet for blessings

[alfaorionis]

Thanks for this very interesting Lesson, we enjoy like always to learn from you PK.

[grijalvaescobedo]

Excelente la función filtrar, únicos mezclado con power pivot . Gracias por compartirlo 🇲🇽👍

[nadermounir]

Very nice video 📹 👍 Thank you for your hard work PK

[jemjoumihicham]

We would like more videos of Power Query and DAX please 🙏🙏

[himamsuvelamakuri]

Hello sir am building an activity tracker for my team can you please help me

[hearphone]

Sir, one small doubt, is there any possible to get particular data from pdf, Img, word files to excel sir