Table.Skip won't work with Text.Contains?

Question

Greetings,&nbsp;I hope there is an easy solution I am missing, but here is my quandry:&nbsp;Table.Skip(Source, each [Column1] &lt;&gt; "UNIT:10917") will remove records before row 7 and this is what I want.&nbsp; The table needs to start at the UNIT record and include all subsequent records.&nbsp; &nbsp;The problem is in the future the source will eventually yield different unit numbers and the query will break.&nbsp; Also, the UNIT record may not always be in the same row, so I need the solution to be dynamic.&nbsp;For some reason&nbsp;Table.Skip(Source, each Text.Contains([Column1], "UNIT:")) doesn't work.&nbsp; The step actually does nothing to the query and does not yield an error.&nbsp; Am I missing syntax?&nbsp;I know extracting the text range to a new column and using that one will work, but I want to see if I can do this in one step.&nbsp; I also know the syntax above will work with Table.SelectRows but that will remove all other rows and I just need to skip down to the designated one.&nbsp;Thank you in advance.

owenauger · Accepted Answer

HI&nbsp;WBarberena&nbsp;
I believe you need to negate the condition:
Table.Skip(Source, each not Text.Contains([Column1], "UNIT:"))
From the Table.Skip documentation:
"the rows that meet the condition will be skipped until a row does not meet the condition."
&nbsp;
Does that work as intended?

Forum Discussion

Table.Skip won't work with Text.Contains?

2 Replies

Related content

Text.Contains M Language

Text.Contain or List.Contain

using if(text.Contains) for multiple conditions in Power Query M

Text.Contains with underscore

[Power Query - M] Text.Contains