Concatenate two column rows based on a particular string

[rpattan]

Hi Team,

Could you look into the need. 

I'm looking for a DAX for a new concated column calculating from column "ID" and column "Name", and concatenated based on expected string of "BC" from column "Type". And the rest of the rows should be null. Please observe two tables for clear understanding...

Actual Data Table:

Type	ID	Name
AB	123	Compensation
BC	345	Variable Pay
CD	127	SPHR
BC	379	Learning
AB	456	Onboarding
BC	497	Performance
CD	230	Goals
DC	107	Succession

Expected Data Table:

Type	ID	Name	Expected Concated Column
AB	123	Compensation
BC	345	Variable Pay	345Variable Pay
CD	127	SPHR
BC	379	Learning	379Learning
AB	456	Onboarding
BC	497	Performance	497Performance
CD	230	Goals
DC	107	Succession

Thank you for your time and patience.

RK

[dedelman_clng · Accepted solution]

ConcatCol = 
IF (
    Type = "BC", 
    CONCATENATE(ID, Name),
    ""
)

Hope this helps,

David

[dedelman_clng · Accepted solution]

ConcatCol = 
IF (
    Type = "BC", 
    CONCATENATE(ID, Name),
    ""
)

Hope this helps,

David

[rpattan]

Hello @dedelman_clng,

It's worked to my requirement. 

And just perhaps if I woul'd like to go with "BC" + "AB" (Just in case!)

Thanks in Advance...

RK

[dedelman_clng · Accepted solution]

IF (
    OR(Type = "BC", Type = "AB")
    CONCATENATE(ID, Name),
    ""
)