Populating rows with missing information

Andrewutter12 — Fri, 13 Nov 2020 15:12:32 GMT

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!

Re: Populating rows with missing information

wdx223_Daniel — Fri, 13 Nov 2020 15:47:31 GMT

Andrewutter12 can add a calculated column in the table

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

Re: Populating rows with missing information

camargos88 — Fri, 13 Nov 2020 16:48:48 GMT

Andrewutter12 ,

Another solution with power query:

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

topic Re: Populating rows with missing information in DAX Commands and Tips

Populating rows with missing information

Re: Populating rows with missing information

Re: Populating rows with missing information