Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI community
I have a table with leader ids. Sometimes a row has a single id and othertimes it multiple ids split by ","
Like this.
I want to add a new row each time I have a "," so no row has more than a single number.
Is this possible?
Solved! Go to Solution.
split column by delimiter, using "," as delimeter. Click the 'To rows' option
@ThomasWeppler add a new column with Text.Split([Column],',') and then exapnd to new rows
Thanks @smpa01
I wnet with @HotChilli solution, but I am sure your solution would have worked as well 🙂
split column by delimiter, using "," as delimeter. Click the 'To rows' option
Thanks @HotChilli
Your solution was super easy to impliment and worked like a charm.