Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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"
User | Count |
---|---|
136 | |
73 | |
72 | |
56 | |
55 |
User | Count |
---|---|
199 | |
95 | |
63 | |
62 | |
51 |