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...
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
Thank you. Yes, I mistyped. It should say "Sought after output". This works. Thank you!