Forum Discussion

Deepak3Arora's avatar
Deepak3Arora
Frequent Visitor
4 years ago
Solved

Create Subset of Data - Group by Month

Hi Team,   Hw can I create a DAX/any other way in Power BI to create a subset of Data as a Table in the form of Matrix.   I Dont need to show it as Visualization but Have this Data in Table Form ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Deepak3Arora ,

     

    Please create the new table.

     

    Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Month],
    "Open",
        CALCULATE ( COUNT ( 'Table'[ID] ), 'Table'[Status] = "Open" ) + 0,
    "Closed",
        CALCULATE ( COUNT ( 'Table'[ID] ), 'Table'[Status] = "Closed" ) + 0
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Deepak3Arora , Use matrix visual,

 

Month on row, Status on column and count of id values

Deepak3Arora's avatar
Deepak3Arora
Frequent Visitor
4 years ago

Hello Amit,

 

I need to save the data as a subset and not visualization.

 

Regards,

Deepak