case statement not working as expected in power BI

[rocku2008_1985]

I have a table in ssms and on using the case statement, it is working as expected as shown:

But doing the same thing in Power BI with addiing columns, conditional statement, it is not working as expected. The screenshot is below. I am stuck here. Please help me out.

[ryan_mayu · Accepted solution]

@rocku2008_1985 

you can try this

= Table.AddColumn(#"Changed Type", "Custom", each if [Format] = "Percentage" then [value]*100 else [value])

[vicky_]

Remove the quotation marks and use square brackets to denote a column - you should have something like [Value] * 100.

(The quotation marks are telling Power Query to return a string, so it's not doing any maths for you)