Please check this:
Dynamic Example - Currency Conversion with Tableau & Google Sheets
Can you attach twbx file or share the excel file. With your twb I am not able to see the data.
Hi Thomas - can't see your data so you will need to provide a twbx to get a good solution
But I did see you plan the blend the data from your main file and the currency conversion file - Suggest you look at joining the files on the "Currency" and the Date
(It will work like a lookup function)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.