Dynamic currency convertion with start and end date

[lcanal]

Hi

We have 3 tables:

CURRENCY

RATES

SALES

Our goal is to show ConvertedAmount in SALES, based on wich CURRENCY user selected in a Slicer.

Thank's!!!

[v-yulgu-msft · Accepted solution]

Hi @lcanal,

Please refer to below measures:

Selected Rate =
CALCULATE (
    LASTNONBLANK ( RATES[RATE], 1 ),
    FILTER ( RATES, RATES[STARTDATE] >= MAX ( SALES[DATE] ) )
)

ConvertedAmount = MAX(SALES[AMOUNT])*[Selected Rate]

Best regards,
Yuliana Gu

[lcanal]

Thank's  a lot @v-yulgu-msft

[v-yulgu-msft]

Hi @lcanal,

Have you worked it out? If so, please kindly mark the helpful reply as an answer so that more users can benefit from it. If you still have any concern, please feel free to ask.

Thanks,
Yuliana Gu