Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.