How to create new table without some elements of a column that contains some Text

[Plopez13]

Hello everyone.

I want to create from my current table two tables:

    -One with all the elements without the rows that have any"Estado Deseado en ..." and "Priorizado en el ...". 

    -Other table only with all the "Estado Deseado en..." and "Priorizado en..."

In other words, I want to have a table with all the "Estado actual por Quincena..." and other with the "Estado deseado en..." and "priorizado en..."

Thanks!

[littlemojopuppy · Accepted solution]

Hi @Plopez13 

On Modeling in the ribbon, create new tables with this

FILTER(
	YourTableName,
	LEFT(Fechas, XX) = "Estado Deseado en" ||
	LEFT(Fechas, XX) = "Priorizado en el"
)


FILTER(
	YourTableName,
	LEFT(Fechas, XX) <> "Estado Deseado en" &&
	LEFT(Fechas, XX) <> "Priorizado en el"
)

In the code where I put XX, figure out how long each of those strings are and use that number.

Hope this helps!

[AllisonKennedy]

@Plopez13  You can do this in Power Query. Start with your original data - rename this query to put RawData_ in front of the table name.

Right click on the query in Queries pane > Reference. Filter this new table for text contains "Estado Deseado en " OR text contains "Priorizado en el"

Then repeat for the other table - right click the RawData_ table, reference. In the new table filter for your other conditions.