Forum Discussion
Multi-exchange rate Conversion (Fixed rate by different time)
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yingjl , I am hoping that there could be a Date Table (as a slicer) to control "Table" and "table2" or more.
However, it seems not possible to do the relationship in this situation.
If the "Date Report" links to the "FX Table" as suggested, when filtering the "Financial Year", it is filtering the year of FX date but not the "delivery date". The result could be different.
In this case, when trying to SUM the price delivered in FY2018, (JPY 11,110) should not be calculated.
Appreciated if there are any ways to calculate with fixed FX% in this scenario.
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.