Split file based on row content

[Anonymous]

I've got a csv file I'm importing into desktop. I've got multiple rows per student and rather than splitting the report coming from the MIS for each school I wondered if there was an easy way to split all the rows with TP Year 1 for example into another table, keeping all the other rows?

Keeping top / bottom X rows wouldn't work as the file increases in size throughout the year.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

In Power Query Editor, right click the table in Queries and select Duplicate to make a copy of the table. 

Then in the new query, expand the down arrow and select the text values to filter the rows.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@Anonymous , In power query, create a copy of table and filter the table based on text search and save.

In dax create a new table

CALCULATABLE(Table, filter(Table, search("TP Year 1 ",Table[resultset],,0) >0))