Remove only text value in a column with text and numbers values

[gsamaral77]

Hello guys, I'm new in the PowerQuery world, so I need a little help.

In my dataset I have a column with mixed types of variables, I need to remove the rows with null, empty and string values, keeping only the rows with numbers values, using PowerQuery. Someone can help me, please?

[Vijay_A_Verma · Accepted solution]

Issue this statement where Source should be replaced by your previous step

= Table.SelectRows(Source, each Value.Is([Column], type number))

[gsamaral77]

It's work!! Thank you very much!!