cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ayahmed
Helper II
Helper II

Retrieve a value of a column from another table

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

ReferenceNumberMailNoDate Submitted to SCDisciplineIN Date
AAB-IN-000008ALE-WIRQ-00693412/27/2018 12:40Facade Engineering 
AAB-IN-000008ALE-WIRQ-00668712/23/2018 5:44Facade Engineering 
AAB-IN-000008ALE-WIRQ-00616912/11/2018 13:11Facade Engineering 
AAB-IN-000008ALE-WIRQ-00647612/18/2018 7:56Facade Engineering 

 

And Inspection notice is having

MailNoSentDateReferenceNumber
AAB-IN-000008-312/27/2018 5:41AAB-IN-000008
AAB-IN-000008-112/18/2018 4:35AAB-IN-000008
AAB-IN-000008-212/23/2018 3:37AAB-IN-000008
AAB-IN-00000812/9/2018 10:58AAB-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

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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]] )



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User IV
Super User IV

@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]] )



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors