How to fill null values in column with previous non-empty value

Question

I have a column 'Resource' in a Table 'Resources', which looks like:&nbsp;ResourceChairnullnullFannullDesk&nbsp;I want to populate this column, such that all null values are replaced with the non empty value before them. So the final output should look like:&nbsp;ResourceChairChairChairFanFanDesk&nbsp;How can I achieve this?

mahoneypat · Accepted Answer

On the Transform tab in query editor, you can use Fill Down (or up) to get your result.

&nbsp;
Pat
&nbsp;

Forum Discussion

Related content

Replace empty values in a matrix with the previous non blank value

Model object names must be non empty

Getting value for previous year based on value name and year slicer

Previous Day Value

Previous Row Value Dax