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.

TatianaGuihur's avatar
TatianaGuihur
Helper I
6 years ago

yes, I only want to delete them in my power bi report. Not in the BD source.

 

How can I do that? 

 

 

mwegener's avatar
mwegener
Most Valuable Professional
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.

  • TatianaGuihur's avatar
    TatianaGuihur
    Helper I
    6 years ago

    Thank you so much for helping you three people. I did what mwegener  said.  Is working now. I understand better.

     

  • Ravi501566's avatar
    Ravi501566
    New Member
    7 months ago

    i could see a number of null i customer_id ,do i filter them out too.

    i am a learning power bi for 3 days now , it would be huge help if u replied.