title: Group by columns on Power BI
body: <p>I have column in which 3-4 different values and data like this </p>
  
  <pre><code>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
  </code></pre>
  
  <p>so currently this show data like this </p>
  
  <pre><code>companyname   servicestatus  count
      abc         inservice      2
      abc         resigned       1
      abc         retired        2
      def         inservice      3
      def         resigned       3
      def         retired        1
  </code></pre>
  
  <p>so on Power BI I want to show like this </p>
  
  <pre><code>companyname   joiners    leavers
  abc              2         3
  def              3         4
  </code></pre>
  
  <p>means in joiners I want to show only inservice but on leavers I want to show resigned and retired both</p>
  
  <p>How do I do this in Power BI
  <a href="https://i.stack.imgur.com/DN43V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DN43V.png" alt="image"></a></p>