I have two tables:
- transaction date, currency code, transaction amount
- effective date, currency code, exchange rate
1transaction date and 2effective date have a relationship
This seems relatively simple but I’m drawing a blank right now. Do you have a recommendation for the most effective way to use DAX to reference date and currency code for each transaction to normalize all sales to USD to create a new column in table 1 “amountUSD”?