Forum Discussion

Andrewutter12's avatar
Andrewutter12
Frequent Visitor
5 years ago
Solved

Populating rows with missing information

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...
  • wdx223_Daniel's avatar
    5 years ago

    Andrewutter12 can add a calculated column in the table 

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