Solved: Re: Numeric Values

kh0050 · ‎06-08-2021

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

C23445

H56777

67000

B45566

67880

89006

V7855

themistoklis · ‎06-08-2021

Best to do this using Power Query and not DAX.

See linked below:

Also try this formula in Power Query:

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

themistoklis · ‎06-08-2021

Best to do this using Power Query and not DAX.

See linked below:

Also try this formula in Power Query:

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

themistoklis · ‎06-08-2021

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

Numeric Values