Split Comma delimited Columns / Cells into Multiple rows Power BI Desktop Tips and Tricks (25/100)

How to Split the Comma delimited value in a column into multiple rows in Power bi ,
Split the column by delimited,
How to change the columns into rows in power bi,
Power BI Desktop Tutorials

#PowerBI #PowerBIDesktop #PowerBITutorials

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[JeffBGroover]

Thanks so much Nags - just what I was looking for

[charliehidalgoz]

Well done, exactly what I was looking for!

[rupaliadhikari]

Same solution can be provided in Paginated query as well??

[landsystems]

Thank you so much for taking the time to make this. You've helped me more than u know!

[bchi]

Seems like you could extract to rows to eliminate the two steps. Thx.

[kalyanreddypatil]

Thanks alot hoping more videos from you

[scottsru]

Excellent video. Exactly what i wanted to see how to do and great examples. Well done!

[vico]

How is possible to remove the duplicated emails in the first column keeping the ProductAccess column with all the values?

[lakshmikanthparvathapuram]

Thanks alot Nag for the Video👍
I have a scenario, where am displaying the child information in the visual for each product selection in the filter section (for eg. If I select Product "A" in the filter section, the childs for Product "A" will display in Visual). Each child can be connected to multiple products. Now, in the visual when I bring product column, for each child, it should display all the connected products in one single column with comma separated. Could you please suggest on this.

[rajasekharkoilada]

Thanks for the video can you provide continue video how to provide RLS in this same case?

[piyushpathak]

Thanks sir for video keep uploading videos daily 🙏

[robingeorge]

Fantastic, thank you so much for this. You are a blessing :-)