Forum Discussion
Helper ICurrency conversion
Hi adieball
You may also use LOOKUPVALUE Function (DAX). You may also go to ‘Edit Queries’ to merge two queries. Then add custom column as requested.
Regards,
Cherie
Community Championis there a join between the tables?
I see few options possible
1) new column created in M (Power Query)
2) new column created in DAX (Power Pivot)
3) measure created using SUMX (Power Pivot)
I'd suggest going with option 1, 3 being second choice, as I expect worse performance
is there a join between CurrencyRate and budget or is that impossible due to different rates per year?
adieballHi
thaks for the quick reply.
in both tables I created the column "CountryYear" which I used to link the two.
Struggling to create the new column in one table as I'd need values from both from it but when I create a new column I can only choose from the current table.
- Stachu
for referencing other table you should use RELATED
https://msdn.microsoft.com/en-us/query-bi/dax/related-function-dax- adieball
That would be a DAX measure instead of an additional column, right?
- Stachu
you need to use RELATED for that
https://msdn.microsoft.com/en-us/query-bi/dax/related-function-dax