Forum Discussion

mmakhlo's avatar
mmakhlo
Frequent Visitor
9 years ago
Solved

Convert Currency

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 c...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi mmakhlo,

     

    The error is caused by the wrong parenthesis.

     

    The correct syntax is:

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
    mmakhlo
    Frequent Visitor
    9 years ago

    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's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi mmakhlo,

       

      The error is caused by the wrong parenthesis.

       

      The correct syntax is:

      Regards,
      Yuliana Gu