Forum Discussion
bilingual
Helper V
Helper VPower 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.
- The values from this row should be split and transformed into two new rows in the same table.
- 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 | Subgroup | Value |
| Test 1 | Mix | 100 |
| Test 1 | A | 200 |
| Test 2 | B | 200 |
Which should be transformed into:
| Type | Subgroup | Value |
| Test 1 | Mix | 50 |
| Test 2 | Mix | 50 |
| Test 1 | A | 200 |
| Test 2 | B | 200 |
3 Replies
- lbendlin
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?
bilingualThis 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
- lbendlin
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
