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, ke...
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))

     

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))

 

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

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