Forum Discussion
Solved
Power BI Parent and Child Sequential data issue
Need help with transforming data in PowerBI. Data is sequential and has a Parent, Child relationship. Sample is in Excel but data is in Smartsheets which I can't manipulate using SQL I...
Hi rouelandrew ,
if you have the same data sheet, you can do it in Power Query by using the option "Fill" down
With the fill-down option, data will be populated in the records below in the same column until the next parent record (not a null value) is found.
talespin
Solution Sage
Solution Sagehi rouelandrew
This is more of a Power Query thing, There are ways in Power Query that you can use to populate parent info against each child record.
If you can copy data in table form rather than image, I can give it a try.