Get Related column in many to many relationship

[jack555]

I have two tables with many to many relationship. need to pull the first followup entered date from second table to first table as column (not as measure) since i would be using this column for some other purposes. I want the results as in the third table.

Please help me with the DAX syntax. I am beginner in DAX. Thanks in advance.

ISSUES
ISSUE_ID	Feedback_ID
1	1111
2	1111
3	1111
4	2222
5	2222
6	3333
7	4444
8	4444
9	4444
10	4444

Followup Table
Followup_ID	Feedback_ID	Followup_Type	Followup_Entered_DT
101	1111	Sign-Off	20/10/2016 0:00
102	1111	Reply Received	21/10/2016 0:00
103	1111	Reply Received	22/10/2016 0:00
104	1111	Referral Sent	23/10/2016 0:00
105	2222	Work done on file	07/12/2016 0:00
106	2222	Sign-Off	09/12/2016 0:00
107	3333	Work done on file	06/03/2017 0:00
108	3333	Work done on file	07/03/2017 0:00
109	3333	Sign-Off	08/03/2017 0:00
110	4444	Work done on file	25/04/2017 0:00
111	4444	Work done on file	26/04/2017 0:00
112	4444	Work done on file	27/04/2017 0:00

What I What
ISSUE_ID	Feedback_ID	First_Followup_Entered_DT
1	1111	20/10/2016 0:00
2	1111	20/10/2016 0:00
3	1111	20/10/2016 0:00
4	2222	07/12/2016 0:00
5	2222	07/12/2016 0:00
6	3333	06/03/2017 0:00
7	4444	25/04/2017 0:00
8	4444	25/04/2017 0:00
9	4444	25/04/2017 0:00
10	4444	25/04/2017 0:00

[jack555]

@Barthel you saved the day. it was so simple, I complicated my self. Thank you very much.

[Barthel · Accepted solution]

Hey @jack555,

You could create a calculated column that retrieves the first value using the MIN function. Put a CALCULATE function around this so that context transition is activated: this converts the row context into a filter context.

First_Followup_Entered_DT = 
CALCULATE ( MIN ( 'Followup Table'[Followup_Entered_DT] ) )