Removing Rows/Data based on a condition

[langemba]

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.

[Joe_Barry · Accepted solution]

Hi @langemba 

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

Joe

[v-aatheeque]

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]

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!

[v-aatheeque]

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]

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!