Calculate Exchange rate for every day

[Tendo23]

Hello community!

Please I need your help to solve my problems with currency.

This is my data model:

The issue is, I don’t have exchange rate for every day.

For e.g.:

Sales on 2nd of January is 10.000 USD. My last rate is from 31st of December, rate 1,0666. Therefore, the calculation is 10.000/1,0666=9375.59€

In the end I would like to have a column with rate and converted sales amount to your.

I already tried the following link, unfortunately I wasnt able to transfer it to my dataset.: Solved: Re: Calculate Exchange rate for every day - Microsoft Fabric Community

My test data set:

Test_Data_Set 

I am thankfull for every help I get! 🙂

[lbendlin · Accepted solution]

Your sample data exchange rates start after your first booking date so the calculation for the first conversion fails.

see attached

[Tendo23]

HI @lbendlin ,

sorry for late response! It works perfectly, thanks a lot for your support!!!!

Tendo