Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Count and group by Power BI

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

like image 712
Amira Bedhiafi Avatar asked Mar 28 '18 13:03

Amira Bedhiafi


People also ask

How do you count and GROUPBY in Power BI?

Power BI Group By countIn the Power Query editor, select the Product column -> Home tab and select the Group by icon from the ribbon. Now Group BY window will open, select the Basic option -> provide the new Column name -> select the operation as Count rows. Click on OK.

Can you do GROUPBY Power BI?

Group By Function in Power BI. Power BI GROUPBY DAX function will group data by collecting the information from two different tables. It works almost similar to the summarized function in Power BI. But, GROUPBY does not allow us to do any implicit calculations using the CALCULATE function.

How do I group values in a column in Power BI?

To use grouping, select two or more elements on a visual by using Ctrl+click to select multiple elements. Then right-click one of the multiple selection elements and choose Group data from the context menu.

Is there a count function in Power BI?

The DAX COUNT function can count cells with repeated values. It can also count dates since Power BI considers dates as a number. The DAX COUNT function does not count the number of boolean function data such as True or False that appeared in the given table.


2 Answers

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.

like image 149
Taterhead Avatar answered Sep 23 '22 23:09

Taterhead


Select Advance editor on table and Select table -> Transfrom Tab -> select table and Group by option -> In Group by Select Advanced -> Select columns and mention the new column name -> give Ok button.enter image description here

like image 41
KARTHIKEYAN.A Avatar answered Sep 24 '22 23:09

KARTHIKEYAN.A