This content has been marked as final. Show 2 replies
i have 1 data source with transactions and dates, and secondary data source with conversion rates and dates. blending on currency AND date (month), i create a table calc like:
sum([AMOUNT])*min([Sheet1 (conversion rates)].[USD per Unit])
this does not return the correct converted totals over a 3 month period. it seems to take the lowest rate for the entire 3 months even though im blending on month and currency.
when i create another view as a table, where the month and currency is included in the viz, it converts properly. but when i do it as a total for the quarter, it does not. any solution for this?