Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Currency Conversion

Hi!!

 

I am writing to ask a favor I was trying but I'm not getting a success. I have 3 tables one is for the selector of the target currency, the other is for sales, and another with the conversion rates between date from and date to

 

Transaction CurrencyTarget CurrencyDate FromDate ToRATE
AUDDKK30/04/2017 00:0029/09/2017 00:00508.46
AUDDKK30/09/2017 00:0030/10/2017 00:00493.68
AUDDKK31/10/2017 00:0029/11/2017 00:00489.23
AUDDKK30/11/2017 00:0030/12/2017 00:00475.23

 

INVOICENUMBERLINECREATIONSEQUENCENUMBERINVOICEDATEShipped DateTarget CurrencyShipped Value
1005018042804/01/2019 00:0002/01/2019 00:00EUR39
10050180421204/01/2019 00:0002/01/2019 00:00EUR111.5
10050180421304/01/2019 00:0002/01/2019 00:00EUR107.75
10050180421404/01/2019 00:0002/01/2019 00:00EUR107.75
10050180421504/01/2019 00:0002/01/2019 00:00EUR107.75
10050180421604/01/2019 00:0002/01/2019 00:00EUR107.75
1005018119807/01/2019 00:0007/01/2019 00:00EUR3
1005018119907/01/2019 00:0007/01/2019 00:00EUR1.64


I am trying to create a dax measure that brings the rate of a selection of target currency and multiply by sales value, but every rate depends on the range of date of the rate table.

Hope you can help me,

 

Thanks

https://www.dropbox.com/s/ktvels8mlf6agbf/SampleFile.pbix?dl=0  

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anonymous ,

     

    Your link cannot be displayed after I open it, and the Target Currency of your two tables are not the same, and the logic cannot be judged

     

    I would like to ask, what do you mean is based on the selection based on the Target Currency, and then check whether it is between the Date From and the Date To according to the selected Target Currency date, if it is, then Shipped Value * RATE

     

    Best Regards,

    Liu Yang

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