M Code use aggregatetablecolumn

[Anonymous]

Hi all,

After unsuccesful googling, I'll try to find an answer here:

I have following data set 

I want to achieve a count on the activities per Case ID preferably in the query (M-code). So in more detail I want to have all distinct Case Id's and I want to count how many Activities happened for a certain case. I am not sure, but I think the aggregatetablecolumn might be useful in order to do this.

The result should look something like this:

Case ID:         Number Of Activities:

1                    10

2                    6

3                    1

and so on.

Can anyone help me with this?

Have a good one!

Thanks,

Bert

[Fowmy]

@Anonymous 

In power query, right-click on the case id column, select GROUP BY,  Choose CountRows

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn