Forum Discussion
Anonymous
4 years agoNot applicable
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
- AnonymousNot applicable
Thank you - that did it !
rgds
Eirik
- Jihwan_KimSuper User
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.