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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.