topic Re: Copy value from one row to underlying rows in DAX Commands and Tips

Copy value from one row to underlying rows

EirikB — Tue, 14 Jun 2022 16:25:15 GMT

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

Re: Copy value from one row to underlying rows

Jihwan_Kim — Tue, 14 Jun 2022 17:08:01 GMT

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.

Re: Copy value from one row to underlying rows

EirikB — Wed, 15 Jun 2022 06:33:02 GMT

Thank you - that did it !

rgds

Eirik