Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |