Copy value from one row to underlying rows

[EirikB]

Hi all !

I have searched for a solution to this problem without luck - hopefully this issue is known to others:

I have a table with date and transactions. The problem is that the date is not repeated on the rows - see example below. I am looking for the soluttion to copy the date and replace the "null" with date - until a new date is reached:

My table:

This should read:

Thankful for any hint and suggestions !

Rgds

Eirik B

[EirikB]

Thank you - that did it !

rgds 

Eirik

[Jihwan_Kim · Accepted solution]

Hi,

One of ways to achieve this is using Fill Down function in Power Query Editor.

Please check the below picture and the attached pbix file.