Replace null with date on row above

[nattaya_be]

My data has date only on the first row of that date, how can I add date to the other row

[otravers · Accepted solution]

Use Fill Down:

https://docs.microsoft.com/en-us/power-query/fill-values-column

[Anonymous]

otravers, thanks very much!

[KT_Bsmart2gethe]

Hi @nattaya_be ,

Select the Date column, Go to the transform tab, click on the fill and then select down.

Regards

KT

[nattaya_be]

Thank you

[otravers · Accepted solution]

Use Fill Down:

https://docs.microsoft.com/en-us/power-query/fill-values-column

[nattaya_be · Accepted solution]

Thank you so much