Forum Discussion
Solved
Help with currency conversion
Hi all, I am rather stuck on the following problem and wonder if anyone can advise? I have a table loaded with values in a single column which are a mixture of currencies. Period Line Va...
artfulmunkeey Hi You can achieve the result without doing unpivoting the columns. What I understand that have two tables like below
You can create a calculated column in your table 2 like
Value in Euro = LOOKUPVALUE(Conversion[EUR],Conversion[Period],'Currency'[Period])*'Currency'[Value]Final output is belowLet me know if you are expecting some other output.
artfulmunkeey Hi You can achieve the result without doing unpivoting the columns. What I understand that have two tables like below
You can create a calculated column in your table 2 like
Value in Euro = LOOKUPVALUE(Conversion[EUR],Conversion[Period],'Currency'[Period])*'Currency'[Value]
Final output is below
Let me know if you are expecting some other output.
Perfect! Thanks so much, that's exactly what I needed