Remove $ character from column if other colum equals to something in Power BI

[Analitika]

Hello,

I would like to ask how to replace character "$" to "" in column if other column equals to value "A" as example.

[rohit_singh]

Hello @Analitika ,

Please refer to the solution here :
Solved: Replace value in Power Query based on condition - Microsoft Power BI Community

Kind regards,

Rohit

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

[danextian]

Hi @Analitika ,

Create a calculated column using DAX similar to below

No $ =
IF (
    CONTAINSSTRING ( Table[Other Column], "A" ),
    SUBSTITUTE ( Table[Original Column], "$", "" ),
    Table[Original Column]
)

or in PQ, create a custom column

if Text.Contains( [Other Column], "A") then Text.Replace([Original Column], "$", "") else [Original Column]

Note: M is case-sensitive.  "A" is not equal to "a"