Remove Text from Specific Column

[Anonymous]

Hi , I am new to Power BI.

Could any one please guide how to remove "Text " from Alpha numeric coulmns. I want to create another column only with numbers to get average of it.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a custom column as below.

Text.Select([Minutes], {"0".."9"})

M code for your reference:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlLwzcwrLUktVoqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Minutes = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Minutes", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Select([Minutes], {"0".."9"})),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type number}})
in
    #"Changed Type1"

[Anonymous]

Hi, 

Thanks for your responses. It can also be done using Delimiter ( Transform > Extract >)

[amitchandak]

This is M language will work in Edit query mode.

In DAX use left, right, mid and search functions.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Well this is ia power query forum. Don't know why we would put Dax in here.

[Anonymous]

I am presuming that you might have decimals or commas in your number. You can adjust  the boldface text below accordingly.

Text.Combine(List.Select( Text.ToList([Minutes]), each List.Contains({"0".."9",".",","}, [Minutes])))