Need to filter a column based on first character being a number or text.

[TroyKurt]

Hi, I have a filed that contains part numbers. Some of the part numbers start with a letter and I would like to be able to filter out all part numbers that begin with a letter. 

Is it possible to right a measure to do this? I haven't had much luch.

[v-shex-msft]

Hi @TroyKurt,

Can you please share some dummy data and expected results to test? It should help us clarify your data structures and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[FrankAT · Accepted solution]

Hi @TroyKurt ,

you can do it like this:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[AlexisOlson]

You can use LEFT to take the first part of a text string.

For example:

FILTER ( TableName, LEFT ( TableName[ColumnName], 1 ) <> "A" )

[TroyKurt]

How do you make it filter all letters, not just "A"?

[AlexisOlson]

Another option would be to list all the letters you want to exclude:

FILTER ( TableName, NOT ( LEFT ( TableName[ColumnName], 1 ) IN { "A", "B", "C", ..., "Z" ) )