Replace every row with the first row value

Hi Applicable88 ,

Create a new custom column, and enter this as the calculation:

previousStepName{0}[Custom]

This will fill the column with the first value in the [Custom] column.

Like this:

Pete

If you prefer, you could transform the existing column instead of creating a new one. Try a conversion to date returning null for values that don't work and then fill down.

= Table.FillDown(
      Table.TransformColumns(
          #"Previous Step Name Goes Here",
          {{"Custom", each try Date.FromText(_) otherwise null, type date}}
      ),
      {"Custom"}
  )