Count and group by Power BI

group-by count powerbi
Sandra Guilep Zouaoui Zandeh picture Sandra Guilep Zouaoui Zandeh · Mar 28, 2018 · Viewed 48.4k times · Source

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:

Click here

The result will be :

Click here

Answer

Taterhead picture Taterhead · Mar 28, 2018

Step 1. Select the table visual where your data is located in the Report Pane.

Step 2. In the Visualizations Pane, right click on the date Value in the Values area (not Filters area) and select Date instead of Date Hierarchy.

Step 3. In the Visualization Pane, right click on the date Value (same place) and instead of Don't Summarize select Count.

Related questions

How to use count and group by at the same select statement

I have an sql select query that has a group by. I want to count all the records after the group by statement. Is there a way for this directly from sql? For example, having a table with users I …

Read More
SQL query for finding records where count > 1

I have a table named PAYMENT. Within this table I have a user ID, an account number, a ZIP code and a date. I would like to find all records for all users that have more than one payment per …

Read More
Pandas count(distinct) equivalent

I am using pandas as a db substitute as I have multiple databases (oracle, mssql, etc) and I am unable to make a sequence of commands to a SQL equivalent. I have a table loaded in a DataFrame with some …

Read More