cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rjain12 Regular Visitor
Regular Visitor

Values of one table to another using dax

Hi 

 

I have two tables

 

table 1

 

id     name

 

1

2

3

4

 

table 2

 

id    name

 

1     alex

2     bob 

3     mike

4     oliver 

5     cathy

 

Now I want to write a query in dax for table 1 for fill in all the names from table 2 in table 1 by matching their ids. Please help

2 ACCEPTED SOLUTIONS

Accepted Solutions
Drors Member
Member

Re: Values of one table to another using dax

Create new calculated column :

DaxName =
var tocheck = Table1[ID] return
LOOKUPVALUE(Table2[Name],Table2[ID],tocheck)

1.PNG

Community Support Team
Community Support Team

Re: Values of one table to another using dax

Hi @rjain12,

 

If you can create the relationship of the two tables, you could try with RELATED() function.

 

 Capture.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Drors Member
Member

Re: Values of one table to another using dax

Create new calculated column :

DaxName =
var tocheck = Table1[ID] return
LOOKUPVALUE(Table2[Name],Table2[ID],tocheck)

1.PNG

Community Support Team
Community Support Team

Re: Values of one table to another using dax

Hi @rjain12,

 

If you can create the relationship of the two tables, you could try with RELATED() function.

 

 Capture.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 269 members 2,882 guests
Please welcome our newest community members: