Replace column values by condition

[Analitika]

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 some not. I want replace concatenated column values $ if it contains company name "cname" etc.

[v-luwang-msft · Accepted solution]

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]

@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

[rohit_singh]

Hello @Analitika ,

Please refer to the solution here : 

https://community.powerbi.com/t5/Desktop/Replace-value-in-Power-Query-based-on-condition/td-p/136732...

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊

[amitchandak]

@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.