Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Parihar1980
Helper II
Helper II

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
v-yulgu-msft
Employee
Employee

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.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

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.
Anonymous
Not applicable

@Parihar1980,

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.