I have tables WIR and Inspection Notice. WIR Table is having follwoing data
And Inspection notice is having
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
Go to 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]] )
Proud to be a Super User!
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.