Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
I know how to split text to row
example 1;3;4,
Text.Split([eerderhulpID],";")
list expand to row
but how if its text in column on different rows. Wat is then insted of ";"
Sorry english is not my first language. But I know, here I mostly find all the answers!
It was so easy 😀. the formule is Text.Split([hulpvraagID],"#(cr)")) of Text.Split([hulpvraagID],"#(lf)")) depends of how..
Thanks for the info, so I have found what I have to do. And...... I have learned about seperators.
Hi,
you can use line feed as the splitter #(lf), example below:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
@Nelleke-NL @RickdeGroot has the answer here: Split Column by Carriage Return in Power Query - BI Gorilla
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 |
User | Count |
---|---|
11 | |
11 | |
9 | |
7 | |
6 |