Forum Discussion

ngct1112's avatar
ngct1112
Post Patron
5 years ago
Solved

Multi-exchange rate Conversion (Fixed rate by different time)

Hi, I am working on a multi-exchange rate Conversion in my model. There are 2 critiria.  1.) Multi-currency to Multi-currency 2.) Exchange rates are fixed in different time (i.e 0.67/AUS in 2019, 0...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi ngct1112 ,

    When creating an active relationship between Date table and Table, an inactive table relationship between Date table and Table2,

    what is your expected output? Like the below picture or anything else?

    If this is your expected output, you can use Userelationship() to modify the [Converted2] measure and set it as not blank in the visual filter.

    Total Price(Converted2) = 
CALCULATE(
    SUMX('Table2',[Net Price(Convert2)]),
    USERELATIONSHIP(Table2[Delivery Date],'Date Link'[Date])
)

     

    Best Regards,
    Yingjie Li

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

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi ngct1112 ,

When creating an active relationship between Date table and Table, an inactive table relationship between Date table and Table2,

what is your expected output? Like the below picture or anything else?

If this is your expected output, you can use Userelationship() to modify the [Converted2] measure and set it as not blank in the visual filter.

Total Price(Converted2) = 
CALCULATE(
    SUMX('Table2',[Net Price(Convert2)]),
    USERELATIONSHIP(Table2[Delivery Date],'Date Link'[Date])
)

 

Best Regards,
Yingjie Li

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

ngct1112's avatar
ngct1112
Post Patron
5 years ago

v-yingjl , this is exactly what I have been trying to do. it work wonderfully. Appreciated so much with your help!