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 ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    8 years ago
    ConcatCol = 
IF (
    Type = "BC", 
    CONCATENATE(ID, Name),
    ""
)

    Hope this helps,

    David

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