Create an amount measure converted to a single currency

[Syndicate_Admin]

Hello dear community, I think my case should be something simple to solve. To the point:

I have a table with 2 columns: [currency] and [amount].

• [currency]: "NIO"; "USD".
• [amount]: Well, it's the number or amount.

Something like this (the table is huge), I put an example of only 3 lines:

Currency	Amount
NINE	50
USD	15
NINE	70

What I want is a single column of amount converted to a single currency, in this case, I want everything to be in USD.

For this, in an excel, the formula could be:

IF ( [currency] = "NIO", [amount]/36.6, [amount])

And it would result in the following:

Currency	Amount	Amount USD
NINE	50	1.3661
USD	15	15
NINE	70	1.9126

I want this same thing in Power PI, in a DAX formula.

I tried to do it in a calculated column, but it shows me the following error, but I don't understand it.

I appreciate you giving me both solutions:

• Calculate column
• DAX Measurement

Thanks in advance

[Ashish_Mathur]

Hi,

Write this calculated column formula

=if(Data[Currency]="NINE",DIVIDE(Data[Amount],36),Data[Amount])

Hope this helps.

[Padycosmos]

I notice an anomaly. In the Table the currency is different from the text "NIO" stated in the measure.

[Syndicate_Admin]

I don't know why your watching the "NINE" word. Maybe, because I wrote it in Spanish, and you are seeing it translated in English. That is not correct.

The word correct is "NIO", that means "Cordobas", this is the currency for Nicaragua.

Forget the word "NINE", the correct is "NIO".

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523