Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.