Forum

Count by Group - no...
 
Notifications
Clear all

Count by Group - not aggregated

3 Posts
2 Users
0 Reactions
73 Views
(@dani104)
Posts: 50
Trusted Member
Topic starter
 

Hello,

Is it possible please, in PQ, to count items per group, non-aggregated?  I'm currently doing the workings in Excel; please see attached example.  But if possible to do in PQ, would likely be more efficient.  

Thank-you.

 
Posted : 09/04/2021 2:20 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Danielle,

Yes, you can number grouped data in Power Query (see link).

Mynda

 
Posted : 09/04/2021 3:59 am
(@dani104)
Posts: 50
Trusted Member
Topic starter
 

Thanks so much, Mynda.

This is exactly what I was looking for.

Regards, Danielle

 
Posted : 09/04/2021 7:22 am
Share: