Numeric Values

[kh0050]

How to remove alphabets from columns so that to have only numeric values. ( see below)

C23445

H56777

67000

B45566

67880

89006

V7855

[themistoklis · Accepted solution]

@kh0050 

Best to do this using Power Query and not DAX.

See linked below:

https://radacad.com/remove-digits-or-keep-them-in-power-bi-using-power-query

Also try this formula in Power Query:

= Table.AddColumn(#"Previous Step", "Keep Numbers", each Text.Combine(List.RemoveItems(Text.ToList([FieldName]),{"A".."z"})))

[themistoklis]

@kh0050 

I have also attached the workspace for you to have a look at