Remove rows according to number of digits in Power Query

[twosixfourBI]

Hi there - I am trying to remove rows in a table using power query. I want to remove all rows where ID_Number column has less than 11 digits.

Example:
99010112341 - keep

245 - remove

Is there a simple way to do this?

Kind regards

[tamerj1 · Accepted solution]

Hi @twosixfourBI 

[amitchandak]

@twosixfourBI , Filter in power query .  Or create a column and filter for true

Number.IntegerDivide([Column],10000000000) >=1