Find exchange rate within a date range

[DallDenmark]

I'm using Navision which only has a starting date in the tables.
I have an exchange rates table as below
I have a transaction line with the posting date 02-04-2015 where I need to add the exchange rate for this date. It is the first in below (6,9464) but how do I find this result with a Power pivot or PowerQuery formula?


[TABLE="width: 308"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Starting Date[/TD]
[TD]Currency Code[/TD]
[TD]Relational Exch. Rate Amount[/TD]
[/TR]
[TR]
[TD]01-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4379[/TD]
[/TR]
[TR]
[TD]02-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4369[/TD]
[/TR]
[TR]
[TD]03-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4372[/TD]
[/TR]
[TR]
[TD]04-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4365[/TD]
[/TR]
[TR]
[TD]05-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4368[/TD]
[/TR]
[TR]
[TD]08-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4382[/TD]
[/TR]
[TR]
[TD]09-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4396[/TD]
[/TR]
[TR]
[TD]10-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4409[/TD]
[/TR]
[TR]
[TD]11-05-2017[/TD]
[TD]EUR[/TD]
[TD]7,4401[/TD]
[/TR]
</tbody>[/TABLE]