Convert Currency

[mmakhlo]

Hello all,

I need to do a currency conversion. Here is my set up

table 1 has the site and currency rate (each site is in a different country)

table 2 has site for each part and the cost calculated in USD

I currently have a 1:many relationship going from table 1 to table 2. What is the best way about calculating the correct cost based on the site?

Cheers

[v-yulgu-msft]

Hi @mmakhlo,

In table 2, you could create a calculated column using this DAX formula:

Real cost = RELATED(Table_1[Currency rate])*Table_2[Cost USD]

Regards,
Yuliana Gu

[mmakhlo]

Thank you for replying @v-yulgu-msft! When I use that formula, I get this error. Do you know what it means?

[v-yulgu-msft · Accepted solution]

Hi @mmakhlo,

The error is caused by the wrong parenthesis.

The correct syntax is:

Regards,
Yuliana Gu