Forum Discussion

amira_bedhiafi's avatar
amira_bedhiafi
Regular Visitor
8 years ago
Solved

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: The result will be :  
  • ChrisMendoza's avatar
    ChrisMendoza
    8 years ago

    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.)

     

     

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

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
8 years ago

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.)

 

 

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