topic Create new table from combination of 2 columns from 2 tables. in DAX Commands and Tips

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

Anonymous — Tue, 28 Apr 2020 17:19:26 GMT

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.

Anonymous — Tue, 28 Apr 2020 19:42:33 GMT

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!!