Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Copy value from one row to underlying rows

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

 

  • 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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you - that did it !

     

    rgds 

    Eirik

  • 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.