Excluding certain items from a column

[bouyazbekj]

Hello everyone,

I have a column of item codes and I would like to only see certain ones. 

For example I want to only see items that start with an E and B from this column 

E0617-0012

E0666-0012

B0605-0052

A0325-0065

C0266-0065

E0069-0005

C0058-0085

B0688-9985

G2215-0085

Thank you 

[v-shex-msft · Accepted solution]

HI @bouyazbekj,

You can enter to query editor and apply a filter with following custom filter expression:

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Text],"E") or Text.StartsWith([Text],"B"))

Full query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RcxRCoAwDAPQu+zbQVZp7T5Vxg4xdv9rWGuHf3kkZIzUIOXIQKE0N6fIzwsCNvLHEzu9FHbeIB8Hm6VqxGrBalReV6q51mAnKhztfAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Text = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Text", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Text],"E") or Text.StartsWith([Text],"B"))
in
    #"Filtered Rows"

Regards,

Xiaoxin Sheng