DallDenmark
New Member
- Joined
- May 3, 2018
- Messages
- 5
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?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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?
| Starting Date | Currency Code | Relational Exch. Rate Amount |
| 01-05-2017 | EUR | 7,4379 |
| 02-05-2017 | EUR | 7,4369 |
| 03-05-2017 | EUR | 7,4372 |
| 04-05-2017 | EUR | 7,4365 |
| 05-05-2017 | EUR | 7,4368 |
| 08-05-2017 | EUR | 7,4382 |
| 09-05-2017 | EUR | 7,4396 |
| 10-05-2017 | EUR | 7,4409 |
| 11-05-2017 | EUR | 7,4401 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
