Matching by date and product id. I need to create a measure and multiply [# Sales Out Quantity] * [C-price] * [E/R] at the specific exchange rate [E/R] for a given day?
In other words, the day's sales must be calculated by the day's exchange rate.
Is there any issue when just using [# Sales Out Quantity] * [C-price] * [E/R] ? If your [% Product ID] and [% Date] are associated correctly between the tables, it should give you the correct result
