Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a column like this
Col 1
mango
orange
mango
grape
orange
mango
orange
mango
apple
need an out put like
mange 4
orange 3
Grape 1
Apple 1
Solved! Go to Solution.
In the query editor, select your Col 1 and hit the Group By button and accept the default aggregation of Count to get this.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
In the query editor, select your Col 1 and hit the Group By button and accept the default aggregation of Count to get this.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.