Forum Discussion

Bebo's avatar
Bebo
Icon for Helper II rankHelper II
3 years ago
Solved

Replace Value in One Column based upon condition in another Column

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), r...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
    Bebo
    3 years ago

    Thank you - worked perfectly.

Bebo's avatar
Bebo
Icon for Helper II rankHelper II
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    Bebo
    Icon for Helper II rankHelper II
    3 years ago

    Thank you - worked perfectly.