Forum Discussion
Add categories from one table to all values in another table
I am creating a P&L in PBI for a population of projects (Table1). Each projects has its individual P&L, each P&L set up with the same set of accounts (Table2). How can I merge the two tables, so that Table1 is set up with all P&L Categories from Table2?
Table1:
Table2: (13 categories showing - total categories 36)
Sought-after output:
Current solution is to copy the Project Sample 36 times and merge all tables before calculating each individual line item.
Thank you.
Are you asking to create the 'Sought after input' for every project row in Table1?
If so, it's not too difficult.
In Table1, Add a custom column which is just the name of the Table2 query. The Intellisense will show you when you start typing.
Then expand the table from the column header
2 Replies
- HotChilli
Community Champion
Are you asking to create the 'Sought after input' for every project row in Table1?
If so, it's not too difficult.
In Table1, Add a custom column which is just the name of the Table2 query. The Intellisense will show you when you start typing.
Then expand the table from the column header