Forum Discussion

TatianaGuihur's avatar
TatianaGuihur
Helper I
6 years ago
Solved

Remove negatives

Hello all,  Its my first time wrinting in this forum.    I would like to delete all the lines that have a negative number in my column "IdComm".  I dont want to filter greater than 0, because is ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi TatianaGuihur ,

     

    Set the filter with Power Query. (Transform data)

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

kumarisahsneha9's avatar
kumarisahsneha9
New Member
1 year ago

Hello all, 

Its my first time wrinting in this forum. 

 

I would like to delete all the lines that have a negative number in my column "IdComm". 

I dont want to filter greater than 0, because is only a filter. I really want to delete them of my table.

 

Thanks in advance for helping me,