Relate two tables via three different categories (multiple relations)

[juan_123]

Hi, I have two different tables with prices.

The first table has dates, products and expiration date.

The second table has dates, crops and a different set of expiration dates. 

I need to select connect both tables through each of these three variables. How can I do that?

For example. I need to compare FASt from "Aceite de soja" 4-2023 with "Soja", 1/5/2023 for the same date. How can I relate both tables to select via those categories?

Many thanks!
Juan

[amitchandak]

@juan_123 , Based on what I got. Create a concatenated column and use that to join. In case of direct query create it using combinevalues

https://learn.microsoft.com/en-us/dax/combinevalues-function-dax

[juan_123 · Accepted solution]

Hi @amitchandak thanks for the answer! I was just thinking about that after posting. Will try combinevalues. Thanks!