Forum Discussion

LisaB's avatar
LisaB
Helper III
7 years ago
Solved

Convert currency amount based on IF statement

Hi,

 

I need to calculate amount into local currency. All entries in local currency (LCY) have blank currency code and currency factor = 0. Example table below.

 

I need help with writing a DAX formula giving me the amount (LCY); if currency factor is = 0, then it should show the amount in the column named amount, if it differs from 0 it should show amount * (1/currency factor).

 

Invoice_NoCurrency CodeCurrency FactorAmount
101010 010 000,00
101011EUR0,097790311 000,00
101012EUR0,097790312 000,00

 

Thanks!

 

Lisa

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    LisaB,

    You can create a calculated column like below: 

    Local Currency =
IF (
    'Table Name'[Currency Factor] = 0,
    'Table Name'[Amount],
    'Table Name'[Amount] * ( 1 / 'Table Name'[Currency Factor] )
)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    LisaB,

    You can create a calculated column like below: 

    Local Currency =
IF (
    'Table Name'[Currency Factor] = 0,
    'Table Name'[Amount],
    'Table Name'[Amount] * ( 1 / 'Table Name'[Currency Factor] )
)