Creating a new column

[3piecechickendi]

Is there a way to create a new column based on the values of another column? In another viz tool, I could use the following --- Case [column_name] when ‘Levi’ then ‘Apple’ else [column_name] END

They were called calculated columns