Currency Exchange Rate

[Syndicate_Admin]

Dear:

Thank you in advance for the support you can give me, I have to show the sales information in local currency and in usd, but as we know the exchange rate is variable in a period of time, so the rate I have in a table called, exchange rate, which has a beginning and end of validity, as well as the exchange factor, and in the second table I have the sale on a certain date, to which I want to add a column that is USD, which would be the sale between the exchange factor on the given date.

Attached the link

https://drive.google.com/file/d/1U73OKoiQ6VDHgQLEjjAIyI1_8fwFFOLR/view?usp=sharing

[v-zhangti · Accepted solution]

Hi, @Syndicate_Admin 

You can try the following methods.

Column:

USD = 
CALCULATE (
    MAX ( TipoCambio[Valor] ),
    FILTER (
        TipoCambio,
        [Desde] <= EARLIER ( Venta[Fecha] )
            && [Hasta] >= EARLIER ( Venta[Fecha] )
    )
) * [Venta]

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Please find the measure to find the rate

Rate =

var validdate=selectedvalue(Venta[Fecha])

var result=calculate(max(TipoCambio[Valor]),validdate>=TipoCambio[Desde]&&validdate<=TipoCambio[Hasta])

return

result

[Syndicate_Admin]

Thank you very much, it's exactly what I needed.

Best regards