Add categories from one table to all values in another table

[sindrekb]

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. 

[sindrekb]

Thank you. Yes, I mistyped. It should say "Sought after output". This works. Thank you!

[HotChilli · Accepted solution]

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