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.
VillyMBI
Resolver I
Resolver IHi 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.
Hey thanks,
Do I only need to do this one time and further updates will be automatic? Or do I have to keep doing it everytime there are new rows added to the data?
- VillyMBI
It is a one time job.