Populating rows with missing information

[Andrewutter12]

Good morning,

I have a table called debtors in my PowerBI report. This shows both sales journal and cash receipt journal both of which have the same unique invoice #. There is also a column that has a project path #. My issue is that the project path # only shows on the rows that are cash receipts and not sales journal. I need to show the project path # on the sales journal row item.

Current table:

Invoice #   Journal          Amount         Project Path #

38010        SJ               $5000                Blank

38010        CR             ( $5000 )            17-20675

Desired table:

Invoice #   Journal          Amount         Project Path #

38010        SJ               $5000                17-20675

38010        CR             ( $5000 )            17-20675

Is there any dax formula I can create to achieve my desired result?

Thank you!

[camargos88]

@Andrewutter12 ,

Another solution with power query:

https://www.myexcelonline.com/blog/fill-values-using-power-query/

[wdx223_Daniel · Accepted solution]

@Andrewutter12 can add a calculated column in the table 

=concatenatex(filter(table,table[invoice #]=earlier(table[invoice #])),table[project path #],",")