Forum Discussion

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
8 years ago
Solved

Groups by columns on Power BI

I have column in which 3-4 different values and data like this companyname servicestatus employee abc inservice abc_e1 abc inservice ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Bakhtawar,

     

    Add a calculated column in DAX, then drag [companyname] to Rows and [Tag] to Columns in a Matrix visual.

     

    Tag =
IF ( Table1[servicestatus] = "inservice", "joiners", "leavers" )

     

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Bakhtawar,

 

Add a calculated column in DAX, then drag [companyname] to Rows and [Tag] to Columns in a Matrix visual.

 

Tag =
IF ( Table1[servicestatus] = "inservice", "joiners", "leavers" )