Add lookup data from another table/column using custom columns

your output seems to be wrong, 503 will never get return because pay run doesn't have that date range.

Here is the solution thou, add new measure in your requistion table:

PayId = 
var r = MAX(Req[Date Created]) 
return Calculate(Max(PayRun[Pay Run ID (Year/Pay Period)]), Filter(
All(PayRun), 
r >= PayRun[Pay Begin Date] && r <= PayRun[Pay Period End Date]
)
)

Hi ksummers68,

parry2k's solution works great in a measure. If you would like to add a column in source table, you just need to make a little modification:

PayId =
CALCULATE (
    MAX ( 'Pay Run ID'[Pay Run ID (Year/Pay Period)] ),
    FILTER (
        ALL ( 'Pay Run ID' ),
        requisition[Date Created] >= 'Pay Run ID'[Pay Begin Date]
            && requisition[Date Created] <= 'Pay Run ID'[Pay Period End Date]
    )
)

Best regards,

Yuliana Gu