Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Replace column values by condition

Hello,   How I could replace column values by specific condition. For example,  I am concatenating company name and journal code.  I know that some companies journal codes contains $ character som...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Analitika ，

    Pls test the below:

    newvalue = IF(FIND("cname",'Table'[value],1,BLANK())<>BLANK(),"&"&""&'Table'[value],'Table'[value])

    Then delete the before column and rename new column:

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

Analitika ,

check this

New column = If(OR(CONTAINS('Journal code','Journal code'[Journalcode],"$"),'Journal code'[Companyname]="Cname"),
CONCATENATE('Journal code'[Companyname], SUBSTITUTE('Journal code'[Journalcode],"$","")),
CONCATENATE('Journal code'[Companyname],'Journal code'[Journalcode]))

Thanks,

Arul