Create new query based on parameters

Hi EladAppelNN,

Sure you could create that table with DAX, see here. 

However if you're bringing your data in and loading that into Power Query, it makes more sense to create it there. To process is really simple. Go to your Products (query1), select Add Custom column

In the dialog box enter the Countries (query2) name, press OK

You'll see a nested table in the new column and with those sideward arrows in the header you can extract fields.

Ps. If this helps solve your query please mark this post as Solution, thanks!