Solved: Calculated column with IF statement

zubairs · ‎06-14-2022

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 · ‎06-15-2022

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

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎06-15-2022

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

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Calculated column with IF statement