Mergin unrelated tables in PBI

[Timo1980]

Hi,

I'm stuck with the following issue, i want to create an product/country list overview that i can populate with sales data, but i also want to see the blanks where there is no data. To do that i want to merge to unrelated tables(lists) and combine it into one list as in the example below. Anyone know how to do this? thanks!

[olgad · Accepted solution]

Hi, create a new table:

New Table= CrossJOIN(Region, Products)

[Timo1980]

that worked perfectly, thank you!

[olgad]

More than welcome! Can you please also give a like as it helps other people discover the answer and get my assistance. Thanks!