Forum Discussion

johnwedeles's avatar
johnwedeles
Icon for Helper III rankHelper III
6 years ago
Solved

Replacing text in column with new text based on condition

Hello:   I am trying to replace a hyphen ("-") with an en dash in an existing column. I know I'd need to use UNICHAR for this. So, I imagine the formula would be something like this:   IF Table N...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    johnwedeles 

    if it is a value in a cell, use substitute

    Column = SUBSTITUTE('Table'[Column1],"-",UNICHAR(8211))

    if it is the name of a measure, you replace the whole measure name