Filter rows starting with two numbers

[Anonymous]

Hey folks, 

I need to filter out the rows that start with two numbers (e.g. "15John"). Is there any way to do so in Power Query? 

[Fowmy]

@Anonymous 

Add this as a new column and filter only TRUE:

= try Value.Is(Number.From(Text.Start([data],2)), type number) otherwise false

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn 

[Anonymous]

Hey @Fowmy , thanks for the response. 

The formula doesn't really work for me.

I am not sure what you mean by 'type number', there is no fixed number I am looking for. It's all the rows that start with 2 numbers. (e.g. 12xx as well as 17xx) 

[Fowmy · Accepted solution]

@Anonymous 

Please check the attached file: https://1drv.ms/u/s!AmoScH5srsIYgYILtIDVwH_Ipqpgng?e=X8cDaq

The new column added in PQ will allow you to filter the rows where the value starts with 2 digits.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[Anonymous]

Many thanks @Fowmy!