CODEWITHSUNDEEP
powerbi
user218030
user218030

Reputation: 117

How to split table by row in Power BI

Simple question: I have a table that needs to be split into 2 tables via a row split and not the column split. How can I achieve this?

Thanks.

Upvotes: 0

Views: 4166

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13440

Duplicate the table, then delete the columns that you do not need from each of the copies.

To duplicate the table, open Power Query Editor by clicking on Edit Queries, right click your table and select Duplicate:

enter image description here

Then in each of the copies, right click on the header of the columns that you don't want, and select Remove. Alternatively, you can select the columns that you want to keep, and select Remove other columns.

enter image description here

Upvotes: 1

Related Questions