How do I combine two columns if it contains the symbol '%'

[daniellamoore29]

I want to combine column 'Metric Value' with 'Metric Unit' only if 'Metric Unit' contains the percentage symbol, otherwise just return the metric value without the symbol. 

[parry2k]

@daniellamoore29 the only concern with this approach would be that it will make the [Metric Value] column as text and you will not be able to perform any calculations on it. So you have to think through the final use case of this concatenated column, is it just for display or do you need to perform some aggregations/calculations on it?

[daniellamoore29]

@parry2k I've had to separate out Metric value with it's symbols for calculations. 

So for example a metric value might be a number or a percentage. 

I want to then push through metric value through to a power BI visual, however if it's 95% it will only show 95 so they don't know if it's a percentage. 

Therefore if metric unit contains a % symbol, I want to combine this with the metric value, but I don't want the number (#) symbol to be combined as this is obvious and I dont want it to show 95# only 95%

[parry2k]

@daniellamoore29 what?? If % symbol then what? Can you provide the example output?