Forum Discussion
Solved
Copying column value until value changes then new value
I have this system that outputs log files but it does so in an infuriating way. The data pretty much looks like this (with more columns) Call ID From To Result Date/Time 11111222 614-1...
Why that just sounds like you need to use Table.FillDown on the GUI. if they are not actually null values, replace that value with nulls and then fill down.
--Nate
Hi Thomas_MedOne,
We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.
Please find below the process to use Power Query for filling down the Call ID values:
- Load the Text/CSV file data into Power BI.
- After loading the data, click on Transform Data to open the Power Query Editor.
- Inspect the Call ID column, where blank rows need to be filled. Replace the blank values with Null if blank cells are not already recognised as nulls.
- Select the Call ID column, navigate to the Transform tab, click on Fill, and choose Down. This will fill all blank cells in the column with the last non-blank value above them.
- Preview the data to ensure that all blank rows under the Call ID column have been correctly filled with the appropriate values.
- Click on Close & Apply in the Home tab of the Power Query Editor to load the data back into Power BI with the filled Call ID values.
Please find the attached screenshot and PBIX file for your reference:
If you find this response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.