Beginners guide to count and split text

[shivaniborade]

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

[amitchandak · Accepted solution]

@shivaniborade , 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