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, I would like to filter the rows of a column that starts with the first two characters "to" and hides them from my table. I do not master the conditions under power query M.
Example: If my line in the "case" column begins with "to" then hide or delete it if possible. Every month the merge of the new files adds this kind of line that bothers me.
Example of line i want delete in the same column :
"to 01 april of 31 april"
"to 01 march of 31 march"
thank you
Solved! Go to Solution.
Try this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKslXSEnNSS1JVcgvUsjLL4HylGJ1opVAXLg8WASJFwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Inserted First Characters" = Table.AddColumn(#"Changed Type", "First Characters", each Text.Start([Column1], 2), type text), #"Filtered Rows" = Table.SelectRows(#"Inserted First Characters", each ([First Characters] = "no")) in #"Filtered Rows"
Basically, create a new column that extracts the first 2 characters. Filter out "to"
Hi @Experteam,
Since you are not familiar with M, please also refer to the snapshot below, which shows Greg's solution.
Best Regards,
Dale
THX guys
At the moment I used the filter at the report level
Try this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKslXSEnNSS1JVcgvUsjLL4HylGJ1opVAXLg8WASJFwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Inserted First Characters" = Table.AddColumn(#"Changed Type", "First Characters", each Text.Start([Column1], 2), type text), #"Filtered Rows" = Table.SelectRows(#"Inserted First Characters", each ([First Characters] = "no")) in #"Filtered Rows"
Basically, create a new column that extracts the first 2 characters. Filter out "to"
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |