Remove Letters in Analysis services

[Anonymous]

Hello everyone , 
I have a table coming from analysis services (so no PowerQuerry unfortunately....) and I want to remove every letter from a string:

and the result should be something like:
30
33
Is that even possible through measure calculation?

(Consider that there might be cases that we have more that 1 letter in the beginning of the row, or more than 1 letters at the end of it)
Thanks

[Anonymous]

@Anonymous 
You cannot remove or replace the current column using DAX, beside you are using Live connection mode, you can only create measures. For you case, try connect to AS model with import mode and using Power Query something like:

    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","C","",Replacer.ReplaceText,{"Column"})

However, you might need to do that for each letter.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@akampianakis well, you could force him with SUBSTITUTE, even though that would be a little stinky. I would need at least 26 of those statements

https://docs.microsoft.com/en-us/dax/substitute-function-dax