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 f...
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] )
)
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] )
)
LisaB's avatar
LisaB
Helper III
7 years ago

Worked like a charm! Thanks.