Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter rows starting with two numbers

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?     
Need Help
Fowmy's avatar
Fowmy
Super User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Fowmy
    Super User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Many thanks Fowmy!