DAX measure filter out table by date and take last record and return value

[froxas]

I need a help to write a DAX measure.

I have one table Contracts with contract_id.

Then I have another table Euribor connected with contract_id.

User selects report date and i need to make measure "euribor" which

- filters out euribor table by contract_id,

- filters out euribor table by valid_from > report date and takes

- takes first record and returns euribor value

It needs to be a calculated measure, nor a calculated column because the result will change of selected report date.