Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @amitchandak thanks for the answer! I was just thinking about that after posting. Will try combinevalues. Thanks!
@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
Hi @amitchandak thanks for the answer! I was just thinking about that after posting. Will try combinevalues. Thanks!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |