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

Return Column from another table in DAX

I have 2 table 

table 1

id name 

1   A

2   B

3   C

 

table 2

EMpid   date

1           11-02-2017 

2            11-02-2014

3            11-02-2013

 

 

I want to explore Date column in table 1 using join or any mathod so that I get Date column as output 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Return Column from another table in DAX

Hi @Parihar1980,

 

New a calculated column in Table1:

Date =
LOOKUPVALUE ( table2[date], table2[EMpid], table1[id] )

Best regards,

Yuliana Gu

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

Re: Return Column from another table in DAX

@Parihar1980,

You can use RELATED function to get your date column from table 2 if you have relationship between these tables. 

Highlighted
Community Support Team
Community Support Team

Re: Return Column from another table in DAX

Hi @Parihar1980,

 

New a calculated column in Table1:

Date =
LOOKUPVALUE ( table2[date], table2[EMpid], table1[id] )

Best regards,

Yuliana Gu

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