Merge 2 rows in same column into 1 row

[zoaph]

Hello everyone

I'm currently stuck in a situation.. I have a table column called 'Accounts', it has 5 different categories. But 2 of it is the same, just separated. Now what I want to do is to combine those two categories into 1 category. Basically, Service + AnotherService = Service. Because I need to get their total sales. So in the visualization, it'll display 4 categories instead of 5.

Can anyone suggest how I go about doing it? Thank you! 

[Zubair_Muhammad · Accepted solution]

@zoaph

One of the ways could be to add a calculated column

New Accounts Column =
IF (
    SEARCH ( "Service", Table1[Accounts], 1, 0 ) > 0,
    "Service",
    Table1[Accounts]
)

[zoaph]

EDIT: His solution was exactly what I wanted. THANK YOU!

But I made one small adjustment. I changed the first "Service" into "AnotherService" so that every "AnotherService" would be changed to "Service".

New Accounts Column =
IF (
    SEARCH ( "AnotherService", Table1[Accounts], 1, 0 ) > 0,
    "Service",
    Table1[Accounts]
)

---

Hi @Zubair_Muhammad, currently in my visualisation, it is looking like this:

What I want is like this:

The AnotherService is a separate category with a different name than Service. If I did the calculated column, wouldn't it only search for Service and miss out on AnotherService?