Forum Discussion
juan_123
3 years agoFrequent Visitor
Relate two tables via three different categories (multiple relations)
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 selec...
- 3 years ago
Hi amitchandak thanks for the answer! I was just thinking about that after posting. Will try combinevalues. Thanks!
amitchandak
Super User
3 years agojuan_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
3 years agoFrequent Visitor
Hi amitchandak thanks for the answer! I was just thinking about that after posting. Will try combinevalues. Thanks!