Forum Discussion
Solved
PowerQuery: Replace Value (Dashes)
Hi Again, I'm trying to replace a value - a DASH particularly. It works, however it also does remove the dash symbol for negative numbers. How do I prevent M from doing that?
Hi ovetteabejuela,
Is the negative number part of a longer peice of text?
Could you create a custom column to preserve the negative number before cleaning your original column?
Hi ovetteabejuela,
Is the negative number part of a longer peice of text?
Could you create a custom column to preserve the negative number before cleaning your original column?
Hi Phil_Seamark, thanks I actually did resort to that solution store (1,-1) in a separate column prior to removing dashes. I hope there was an option to tick to exclude dashes that precedes a number though - an out-of-the-box solution.
Thanks.