Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
How would I transform column 1 such that blank values are replaced with the value from the preceding row, so rows 266 & 267 would contain "Use Of Fire Evacuation Chai", row 270 "2001 Manual Handling (Indoor), 272 "1251 Cscs - Health And Safety At" etc.
In psudo code it would be something like...
if currentRow.column1.value does not contain data then currentRow.column1.value = precedingRow.column1.value
Solved! Go to Solution.
Ok, Please follow this:
1. Select your column
2. Go to Tranform - Replace Values
Value to Find --- Empty
Replace with ---- null
3. Transform ---Fill Down
Ready
Regards
Victor
@cymorg ,
So your requirement is to refer to previous or next row in power query, right? You can achieve this without adding an addtional index column, please refer to this blog: https://www.thebiccountant.com/2018/07/12/fast-and-easy-way-to-reference-previous-or-next-rows-in-po...
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In this scenario "In Query Editor with Fill Down Option" does nothing.
Ok, Please follow this:
1. Select your column
2. Go to Tranform - Replace Values
Value to Find --- Empty
Replace with ---- null
3. Transform ---Fill Down
Ready
Regards
Victor
@Vvelarde Victor - So, Transform --- Fill Down creates a Table.FillDown M Query function call. This function acts on the specified column's null values, ignoring non-null values. Therefore, converting empty strings to null before calling this function results in the desired outcome.
It's perfectly clear now thanks to you. 10/10 Thanks.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.