Forum Discussion
Add Column based on cell index
Hi Group
I need help with this .. My data looks like below table "Column1" & "Column2".
I want to create new column in Powerbi called "Result".
This colum should have Column1 value as shown in the Result column in below table..
| Column1 | Column2 | Result |
| TC number123 | xyz1 | TC number123 |
| xyz1 | TC number123 | |
| xyz2 | TC number123 | |
| xyz3 | TC number123 | |
| xyz4 | TC number123 | |
| xyz5 | TC number123 | |
| ERROR | TC number123 | |
| ERROR | TC number123 | |
| xyz8 | TC number123 | |
| TC number234 | abc1 | TC number234 |
| abc1 | TC number234 | |
| abc2 | TC number234 | |
| abc3 | TC number234 | |
| ERROR | TC number234 | |
| ERROR | TC number234 | |
| abc6 | TC number234 | |
| abc7 | TC number234 | |
| TC number555 | abc1 | TC number555 |
| abc1 | TC number555 | |
| abc2 | TC number555 | |
| abc3 | TC number555 | |
| ERROR | TC number555 | |
| ERROR | TC number555 | |
| abc6 | TC number555 | |
| abc7 | TC number555 |
pls see my video
Hi Anonymous
Try the Fill Down transformation in Power Query. I'ts on the Transform ribbonDid I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!
Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181
3 Replies
pls see my video
Hi Anonymous
Try the Fill Down transformation in Power Query. I'ts on the Transform ribbonDid I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!
Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181