Forum Discussion
Dynamic column values based on second table
Hi All,
I need some info where I have 2 tables without the relationship, I need to find SID value from another table if both matches Yes nor no.
what are the options in the direct query to handle this issue
Column1Column2
| Table 1 | ||
| ID | SID | |
| 1 | 7683739 | |
| 2 | 8790111 | |
| 3 | 7683739 | |
| Table 2 | Column1 | |
| SID | ||
| 7683739 | ||
| 7649463 | ||
| 7683739 |
Thank you
NG
Anonymous,
Create a measure in Table 1 using DAX below:
Measure = CALCULATE(MAX('Table 1'[SID]), FILTER('Table 1', 'Table 1'[SID] in VALUES('Table 2'[SID])))Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Anonymous,
Create a measure in Table 1 using DAX below:
Measure = CALCULATE(MAX('Table 1'[SID]), FILTER('Table 1', 'Table 1'[SID] in VALUES('Table 2'[SID])))Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.