Search code examples
powerbidaxformulapowerquery

Fill down skipping blanks

I am trying to use fill down function available in power query to replace black cells with previous values. Below is the sample of data I am working on;

enter image description here

The goal is to repeat values in column Status for respective IDs. Using Fill down would be easy except for the coloured instances as there is no value against those IDs and I would want them blank as there is no value for them.

The desired output is as follows;

enter image description here

Is there is DAX formula which I can use to justify the need?

Truly appreciate your help.

Solution

  • Start point:

    enter image description here

    Select status column and replace blank with null.

    enter image description here

    enter image description here

    Click ID column and then Group By using following options.

    enter image description here

    enter image description here

    Add a custom column as follows:

    enter image description here

    Remove first two columns.

    enter image description here

    Click expand arrows on top right.

    enter image description here