March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Why Doesn't "Fill Down" Work When Trying to Fill Empty Rows with Data from Above
Solved! Go to Solution.
The values below have to be null, not blank or space. Just right click to copy the blank value, click replace values, replace with null. Then fill down.
--Nate
By using fill down, the null value (not blank cell) are replaced by the previous value, in your case, change your data type (or replace command) into text to change the blanck cell to null then use fill down
The values below have to be null, not blank or space. Just right click to copy the blank value, click replace values, replace with null. Then fill down.
--Nate
I should trimmed text fist then replaced the value
thank you for your support
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.