Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Power BI table - split one particular row and transform into two rows

Hi, i have an excel data table with multiple values:

One of these rows contains data which has a faulty definition i cant change the rawdata.

  1. The values from this row should be split and transformed into two new rows in the same table. 
  2. The values should be split acording to the weight of two variables in the same table.

Is is possible in Power bi or by SQL code before dataload?


Example of existing data:


Type SubgroupValue
Test 1Mix100
Test 1A200
Test 2B200


Which should be transformed into:


Test 1Mix50
Test 2Mix50
Test 1A200
Test 2B200


Super User
Super User

There is not enough information in your sample data? How do you decide which row to split, and where is the ratio mentioned?

This is just an example, but it is Test 1 with Subgroup Mix which needs to be split in to the 2 Mix subgroups.


The ratio is the percentage between Test 1 and Test 2, in the example, it is 50/50

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors