Create new table from combination of 2 columns from 2 tables.

[Anonymous]

I have sales and forecast data and want to create a table containing only the product codes and categories.

For one of both I would do the following

Products = DISTINCT(UNION(VALUES(germany_sales[Product]); VALUES( forecast_germany[Product Number (SKU)]))

But I want to to it for the combination Product + Product category. 

[harshnathani]

HI @Anonymous ,

Please share sample data along with the columns of your table to help you with this.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!