Forum Discussion
How to Copy Value from Previous Row (Main Line) to Its Succeeding Rows (Details)
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!
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
2 Replies
- Jihwan_Kim
Super User
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