Forum Discussion
Solved
Numeric Values
How to remove alphabets from columns so that to have only numeric values. ( see below)
| C23445 |
| H56777 |
| 67000 |
| B45566 |
| 67880 |
| 89006 |
| V7855 |
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"})))
2 Replies
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"})))