Forum Discussion

rpattan's avatar
rpattan
Icon for Advocate I rankAdvocate I
8 years ago
Solved

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

Need Help

3 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    8 years ago
    ConcatCol = 
IF (
    Type = "BC", 
    CONCATENATE(ID, Name),
    ""
)

    Hope this helps,

    David

    • rpattan's avatar
      rpattan
      Icon for Advocate I rankAdvocate I
      8 years ago

      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's avatar
        dedelman_clng
        Icon for Community Champion rankCommunity Champion
        8 years ago
        IF (
    OR(Type = "BC", Type = "AB")
    CONCATENATE(ID, Name),
    ""
)