Forum Discussion
Beginners guide to count and split text
Hello,
I wanted to know the most efficient way of splitting column " Language of documents to be printed" and counting it.
I tried the Count.List but ive been getting an error.
The objective is to give a count of each language individually.
Thank you
Anonymous , A new column in the power query
List.Count(Text.Split([ Language of documents to be printed], ";"))
Text.Split: https://youtu.be/Fn5mNEuRNVg
List.Count and List.Distinct: https://youtu.be/zNREVnoAHwM
1 Reply
Anonymous , A new column in the power query
List.Count(Text.Split([ Language of documents to be printed], ";"))
Text.Split: https://youtu.be/Fn5mNEuRNVg
List.Count and List.Distinct: https://youtu.be/zNREVnoAHwM