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

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

Analitika , you can replace in power query .

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.