Results 1 to 2 of 2

Thread: Delete rows if a condition is not met
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2015
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Delete rows if a condition is not met

    I am just starting to learn to use Power Query. I would like to delete any rows that do not contain "Err" and keep any rows that have no data in a certain column. If I was writing code in a macro, I would know how to do this but with Power Query I am really unsure,

    I know I can use the filter option but the data in this particular column changes drastically from month to month.

    Any pointers for this newbie?

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Delete rows if a condition is not met

    You just use the filter buttons at the top of the table. Select one, and then apply the filter you need. If you need to filter logically across more than one column, you can add a new, custom column and build he logic etc in that column to return true or false, then filter out that column
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •