USD value where I have two currency Euro and USD

[Munawar1881]

I have a situation, I have two currencies USD and Euro and in the column its show the exact value with their status. I want to add a new column of Value in USD where all the value should be in USD. how can I do that. 

I mean if the currency is Euro then multiply with 1.2 and its dollar then remain same.

Thank you

[v-yangliu-msft · Accepted solution]

Hi  @Munawar1881 ,

Here are the steps you can follow：

1. Create calculated column.

Column =
IF(
    'Table'[Group]="Euro",
    'Table'[Amount] * 1.2 ,'Table'[Amount])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Munawar1881]

can anyone help me to solve this issue please. I need the DAX formula to solve it if the amount status is dollar then dont calculate it will be the same number and if its Euro then multply with exchange rate colum to be in dollar

[PijushRoy]

@Munawar1881 

Please shaow expected result also in snap for few sample rows and calculation you want

[Munawar1881]