How to Copy Value from Previous Row (Main Line) to Its Succeeding Rows (Details)

[Anonymous]

I'm trying to copy the Invoice # values to its succeding blank rows (or breakdown).

Here's what my data looks like: 

Transaction	Type	Amount
Invoice #1
blank	Invoice	$20
blank	Payment	$10
Invoice #2
blank	Invoice	$30
blank	Payment	$20
blank	Credit Memo	$5

Desired Output:

Transaction	Type	Amount
Invoice #1
Invoice #1	Invoice	$20
Invoice #1	Payment	$10
Invoice #2
Invoice #2	Invoice	$30
Invoice #2	Payment	$20
Invoice #2	Credit Memo	$5

Any ideas on how to do this in Power Query or Dax. Thanks in advance!

[Anonymous]

Got it! Been using power query for a while but it's my first time to know about the Fill Down function. Many thanks!

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

I suggest doing this in Power Query Editor.

Please make sure that the blank value need be shown as null, like the below video.

https://www.dropbox.com/s/tg7shb4lzkfi6n4/Presentation2.mp4?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM