Forum Discussion

molinamike's avatar
molinamike
Frequent Visitor
3 years ago
Solved

POWER BI - Power Query Editor - FIND SPECIFIC VALUE AND DELETE ALL REMAINING ROWS

I have a table named "table1" that contains thousands of entries.  However, I would like to search down the "employee" column to find the first row that contains "NNN".  I want to delete all remaining rows after "NNN".  Please help!!!

1 Reply

  • molinamike's avatar
    molinamike
    Frequent Visitor

    I was able to get the answer from ChatGPT...thx.