Forum Discussion
Andrewutter12
5 years agoFrequent Visitor
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...
- 5 years ago
Andrewutter12 can add a calculated column in the table
=concatenatex(filter(table,table[invoice #]=earlier(table[invoice #])),table[project path #],",")
wdx223_Daniel
5 years agoCommunity Champion
Andrewutter12 can add a calculated column in the table
=concatenatex(filter(table,table[invoice #]=earlier(table[invoice #])),table[project path #],",")