Populating rows with missing information

Question

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.&nbsp;Current table:&nbsp;Invoice #&nbsp;&nbsp; Journal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Project Path #38010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Blank38010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( $5000 )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17-20675&nbsp;Desired table:&nbsp;Invoice #&nbsp;&nbsp; Journal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Project Path #38010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17-2067538010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( $5000 )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17-20675&nbsp;Is there any dax formula I can create to achieve my desired result?&nbsp;Thank you!

wdx223_daniel · Accepted Answer

Andrewutter12&nbsp;can add a calculated column in the table&nbsp;=concatenatex(filter(table,table[invoice #]=earlier(table[invoice #])),table[project path #],",")

Forum Discussion

Populating rows with missing information

2 Replies

Related content

Missing information

missing data

Population dynamic graaph

missing data

Generating Missing Data