Calculated column with IF statement

[zubairs]

I have two currencies in my dataset, "GBP" & "Euros".

I would like to create a Calculated column where I convert "GBP" to "Euros" and leave "Euros" as is.

I am trying it with the following IF statement but I keep getting an error.

=IF(
       [CURRENCY]="€",
                                   [Value],
                                               [Value]/.85)

[BA_Pete · Accepted solution]

Hi @zubairs ,

You're trying to use DAX in Power Query, which uses M.

The correct syntax would be:

if [CURRENCY] = "E" then [Value] else [Value] / 0.85

Pete