Group by columns on Power BI

0 votes

I have column in which 3-4 different values and data like this

companyname   servicestatus  employee
abc           inservice       abc_e1
abc           inservice       abc_ew1
abc           resigned        abc_2
abc           retired         abc_3
abc           retired         abc_23
def           inservice       def_12
def           inservice       def_13
def           inservice       def_14
def           resigned        def_3
def           resigned        def_4
def           resigned        def_5
def           retired         def_3

so currently this show data like this

companyname   servicestatus  count
    abc         inservice      2
    abc         resigned       1
    abc         retired        2
    def         inservice      3
    def         resigned       3
    def         retired        1

so on Power BI I want to show like this

companyname   joiners    leavers
abc              2         3
def              3         4

How do I achieve it?

Sep 25, 2018 in Power BI by Hannah
• 14,080 points
34 views

1 answer to this question.

0 votes

On power BI desktop, do the following

  1. Add the necessary tables to the data model using "Get Data"
  2. Setup the relationships from the designer, if needed
  3. To create the grouping, click on Edit Queries and choose Group By
  4. Add Group by selecting appropriate tables and then click Close & apply button
answered Sep 25, 2018 by Kalgi
• 37,320 points

Related Questions In Power BI

0 votes
1 answer

Power BI Report Viewing on Local Repository?

Use REST API to embed the reports in ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 37,320 points
60 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 37,320 points
3,780 views
0 votes
1 answer

Power BI : Time-based drill downs powered by Azure Data Warehouse

I don't really think you need to ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,190 points
49 views
+1 vote
2 answers

403 error thrown by power bi report server when trying to get list of data sets

Hey @saranya, Try removing the header and ...READ MORE

answered Oct 29, 2018 in Power BI by Kalgi
• 37,320 points
155 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
59 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
480 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 14,080 points
87 views
0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 37,320 points
80 views
0 votes
1 answer

Display power bi report on my desktop application

Power BI has a new feature called ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 37,320 points
29 views
0 votes
2 answers

Send dashboards and reports as automated emails on power bi

check this: https://blog.devscope.net/2018/05/30/how-to-schedule-and-s ...READ MORE

answered Mar 21 in Power BI by Bob Jenkins

reshown Mar 22 by Vardhan 1,581 views