How to add two rows and create a new column in Power Bi

[zzzsharepoint]

I have this table 

Class	Category	Cost
A	CPU	4
A	Memory	3
A	Network	10
A	Disks	2
B	CPU	4
B	Memory	10
B	Disks	11

And the table I want is to add rows of CPU and Memory for each Class and at last it turns out like this. How can I do this?

Class	Category	Cost
A	CPU&Memory	7
A	Network	10
A	Disks	2
B	CPU&Memory	14
B	Disks	11

[v-zhangti · Accepted solution]

Hi, @zzzsharepoint 

You can try the following methods.
Column:

New Category = IF(OR([Category]="CPU",[Category]="Memory"),"CPU&Memory",[Category])

Sum Cost = 
CALCULATE ( SUM ( 'Table'[Cost] ),
    FILTER ( 'Table',
        [Class] = EARLIER ( 'Table'[Class] )
            && [New Category] = EARLIER ( 'Table'[New Category] )
    )
)

New Table:

New table = SUMMARIZE('Table','Table'[Class],'Table'[New Category],'Table'[Sum Cost])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zzzsharepoint]

@amitchandak I checked the video what you have shared and that has no where with the question asked. I am not looking to summarize all the rows here.. its only one with values CPU and Memory and also looking to add the Cost for these values. I am looking to get that as a new table. Your Video talks about summarize function which I cant use here. Please check the question and respond.

[amitchandak]

@zzzsharepoint , use the power query and table method

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[zzzsharepoint]

And I am looking to Add two values not just concatenate two strings

[zzzsharepoint]

Can you please show with an example?