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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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