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
C489449
C489449
C489449
C489449

 

Looks like this would be done in advanced editor. Looking for guidance on the formula.

Need Help
  • Joe_Barry's avatar
    Joe_Barry
    1 year ago

    Hi langemba 

     

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

     

     

    Joe

5 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    1 year ago

    Hi langemba 

     

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

     

     

    Joe

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi langemba ,

      If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

       

      Should you have any further questions, feel free to reach out.
      Thank you for being a part of the Microsoft Fabric Community Forum!

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi langemba ,

        It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
        If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
        Looking forward to your reply!