Forum Discussion
clarkpaul
Helper I
Helper IJoining 2 tables based on a Date Range
Drivers deliver a machine and then call us to update the status. (Delivery Complete, Incomplete, Damaged, etc.) The delivery date is from one table and the debrief date is from another table. The ...
Hi clarkpaul,
One of the options is to create a calculated column like this:
In plain text:
Debrief Date Calculated = VAR currentDate = [Delivery Date] VAR currentSN = [Serial Number] RETURN MINX ( FILTER ( 'Table B', [Serial Number] = currentSN && [Debrief Date] >= currentDate ), [Debrief Date] )Best Regards,
Alexander
barritown
Solution Sage
Solution SageHi clarkpaul,
One of the options is to create a calculated column like this:
In plain text:
Debrief Date Calculated =
VAR currentDate = [Delivery Date]
VAR currentSN = [Serial Number]
RETURN MINX ( FILTER ( 'Table B', [Serial Number] = currentSN && [Debrief Date] >= currentDate ), [Debrief Date] )Best Regards,
Alexander