Retrieve a value of a column from another table

[Anonymous]

I have tables WIR and Inspection Notice. WIR Table is having follwoing data

ReferenceNumber	MailNo	Date Submitted to SC	Discipline	IN Date
AAB-IN-000008	ALE-WIRQ-006934	12/27/2018 12:40	Facade Engineering
AAB-IN-000008	ALE-WIRQ-006687	12/23/2018 5:44	Facade Engineering
AAB-IN-000008	ALE-WIRQ-006169	12/11/2018 13:11	Facade Engineering
AAB-IN-000008	ALE-WIRQ-006476	12/18/2018 7:56	Facade Engineering

And Inspection notice is having

MailNo	SentDate	ReferenceNumber
AAB-IN-000008-3	12/27/2018 5:41	AAB-IN-000008
AAB-IN-000008-1	12/18/2018 4:35	AAB-IN-000008
AAB-IN-000008-2	12/23/2018 3:37	AAB-IN-000008
AAB-IN-000008	12/9/2018 10:58	AAB-IN-000008

Refarnce number is same for different mail number and sent date,

I want to add Sent date from Inspection notice to WIR columan IN date.

Is it possible

[amitchandak · Accepted solution]

@ayahmed , Try to create a new column in WIR as

maxx(filter(Inspection, Inspection[ReferenceNumber] á WIR[ReferenceNumber] && Inspection[Date Submitted].date >- WIR[SentDate].date), WIR[SentDate]] )