cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Count and group by

I am beginner at Power BI and I'm trying to group my data by "Opp title" and count the number of rows of dates:

jHpfe.png

The result will be :

 

ML2dL.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Hello @amira_bedhiafi,

 

Please try something like the following:

 

= Table.Group(#"Changed Type", {"Opp title"}, {{"CountRows", each Table.RowCount(_), type number

You will probably want to use the Group By in the ribbon; Transform -> Group By -> Window as shown below as I do not know the steps that have been applied to your dataset. (e.g. #"Changed Type" is the last step in my sample dataset.)

 

Capture.PNG

 

It is not necessary to count specificially dates any row count will do.






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

1 REPLY 1
Highlighted
Super User I
Super User I

Hello @amira_bedhiafi,

 

Please try something like the following:

 

= Table.Group(#"Changed Type", {"Opp title"}, {{"CountRows", each Table.RowCount(_), type number

You will probably want to use the Group By in the ribbon; Transform -> Group By -> Window as shown below as I do not know the steps that have been applied to your dataset. (e.g. #"Changed Type" is the last step in my sample dataset.)

 

Capture.PNG

 

It is not necessary to count specificially dates any row count will do.






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors