Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Plopez13
Frequent Visitor

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

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..."

 

Captura333333.PNG

 

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!

 

1 ACCEPTED SOLUTION
littlemojopuppy
Community Champion
Community Champion

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!

View solution in original post

2 REPLIES 2
littlemojopuppy
Community Champion
Community Champion

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
Super User
Super User

@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.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.