cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ng2018 Frequent Visitor
Frequent Visitor

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
 IDSID
 17683739
 28790111
 37683739
   
   
Table 2Column1 
 SID 
 7683739 
 7649463 
 7683739 

 

Thank you

NG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dynamic column values based on second table

@ng2018,

 

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])))

Capture.PNG 

 

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 1
Community Support Team
Community Support Team

Re: Dynamic column values based on second table

@ng2018,

 

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])))

Capture.PNG 

 

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.