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

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
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