Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Currency Exchange Rate

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...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

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

    Best regards