Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How to delete records in a table?

I'm using a table in Desktop Power BI in which one of the fields (distributionID) sometimes has the value -1. Then this record has not to be included in the calculations. Those records prevents me to relate this table to another table with more information about this distribution.

 

How can I delete those records (distributionID = -1) in Power BI Desktop.

 

I can solve this problem in the original data by adapting the sql-view i'm using to import this data, but i like to keep the number of views as low as possible, but I want also to keep the imported data as close as possible to the real data.

I know i can solve the problem by adapting each measure to a calculate instruction where i can add a filter (distributionID <> -1).

 

Thanks in advance for any suggestion.

 

Need Help
  • Baskar's avatar
    Baskar
    10 years ago

    Hey buddy

     

    I understand your prob like this way,

    u have to remove the record which distributionID = -1 correct ? if yes pls follow this stepd

     

    go to Query Editor window, and pick your column(distributionID)  click the downarrow

     

     

     

    chose number filter and pick is "Doesnot equal option" from there

    and

     

     

    lets try

1 Reply

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    Hey buddy

     

    I understand your prob like this way,

    u have to remove the record which distributionID = -1 correct ? if yes pls follow this stepd

     

    go to Query Editor window, and pick your column(distributionID)  click the downarrow

     

     

     

    chose number filter and pick is "Doesnot equal option" from there

    and

     

     

    lets try