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 hand...
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.
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.