Filter row with Power query m

[Experteam]

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

[v-jiascu-msft]

Hi @Experteam,

Since you are not familiar with M, please also refer to the snapshot below, which shows Greg's solution.

Best Regards,
Dale

[Experteam]

THX guys

At the moment I used the filter at the report level

[Greg_Deckler · Accepted 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"