Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rpattan
Advocate I
Advocate I

Concatenate two column rows based on a particular string

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:

TypeIDName
AB123Compensation
BC345Variable Pay
CD127SPHR
BC379Learning
AB456Onboarding
BC497Performance
CD230Goals
DC107Succession

 

Expected Data Table:

TypeIDNameExpected Concated Column
AB123Compensation 
BC345Variable Pay345Variable Pay
CD127SPHR 
BC379Learning379Learning
AB456Onboarding 
BC497Performance497Performance
CD230Goals 
DC107Succession 

 

Thank you for your time and patience.

 

RK

2 ACCEPTED SOLUTIONS
dedelman_clng
Community Champion
Community Champion

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

Hope this helps,

David

View solution in original post

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

View solution in original post

3 REPLIES 3
dedelman_clng
Community Champion
Community Champion

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

Hope this helps,

David

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.