Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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 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

jminanoc_1-1653750287585.png

jminanoc_2-1653750397734.png

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

  • 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.

3 Replies

  • 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
  • v-zhangti's avatar
    v-zhangti
    Community 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.