Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
107 | |
83 | |
70 |