Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

M Code use aggregatetablecolumn

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

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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