Forum Discussion

gsamaral77's avatar
gsamaral77
Icon for Helper I rankHelper I
4 years ago
Solved

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

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?

 

 

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

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

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

     

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

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

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