Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Solved! Go to Solution.
@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
@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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.