Dates and Fortnights

[Babycakes]

Good afternoon

I have a date table set out in File : capture  where I have the start date and end date.  Then end date to match periods."FNE"

This is on one table 1

On table 2 I have a "shift start date".  

I need to have a colum on Table 2 that returns;

if Shift start date is between start date and End date , return FNE date.

Can you assist please?

[Babycakes]

  

[amitchandak · Accepted solution]

@Babycakes , Assume you have table 1 and table 2

a new column in table 2

Maxx(filter(Table1, Table2[Shift start Date] >= Table1[Start Date] && Table2[Shift start Date] >= Table1[end  Date] ), Table1 [FNE])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8