Replace Value in One Column based upon condition in another Column

[Bebo]

I am trying to create a dax expression that will replace the value in one column based upon a condition in another column. For instance, in the following table, if the "gamecode=1" in Type Column), replace "1" in TypeID column with "Game 1".

Any suggestions?

 

Type	Type ID
gamecode	0
gamecode	1
sensor state	1

[Anonymous · Accepted solution]

Hi @Bebo,

You can create a calculated column with SUBSTITUTE function to repalce values based on other column values:

Replaced =
IF (
    Table[Type] = "gamecode",
    SUBSTITUTE ( Table[Type], "code", Table[Type ID] )
)

Regards,

Xiaoxin Sheng

[parry2k]

@Bebo with DAX you cannot replace the value but you can add another conditional column

New Type Column = 
IF ( Table[Type] = "GameCode", "Game 1", "Else Value" )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Bebo]

Thanks you for the quick response.

I could not get that to work. What I am trying to is this:

If Column Type = "game code" AND Column TypeID = "1", Output in conditional column would be "Game 1". Then I would repeat this for other TypeID numbers.

[Anonymous · Accepted solution]

Hi @Bebo,

You can create a calculated column with SUBSTITUTE function to repalce values based on other column values:

Replaced =
IF (
    Table[Type] = "gamecode",
    SUBSTITUTE ( Table[Type], "code", Table[Type ID] )
)

Regards,

Xiaoxin Sheng

[Bebo · Accepted solution]

Thank you - worked perfectly.