Forum Discussion

langemba's avatar
langemba
New Member
1 year ago
Solved

Removing Rows/Data based on a condition

Need to remove a large number of rows that have in invoice number with a C in the front/first. In the data set I only want rows-data-columns that reference invoices without a C.  Invoice C4894...
  • Joe_Barry's avatar
    1 year ago

    Hi langemba 

     

    In Power Query just filter the column and filter where the Invoice doesn't begin with C

     

     

    Joe