Using replace function for multiple values

Hello! I am trying to create a custom column where I need to use the replace function to change several items at once. Just for sake of simplicity, let's say I have a category column which can be "A", "B", "C", "X", "Y" and "Z".

I wanted to create a custom column where every instance of "X" is replaced by "A", "Y" is replaced by "B" and "Z" is replaced by "C". How can I write this formula for it to be valid? (I tried all different ways to write it as I could think of and I got a syntax error every single time).

Thank you very much!

Hi @casimiroperez
For reference: https://www.metabase.com/docs/latest/users-guide/expressions-list.html#replace
You would do something like this:
replace(replace(replace([column], "X", "A"), "Y", "B"), "Z", "C")

Thank you very much, @flamber!
I was trying to write the column name every time after opening parenthesis (that's why I was having problems).
You saved me again :slight_smile: