Forum Discussion

rocku2008_1985's avatar
rocku2008_1985
Icon for Helper I rankHelper I
3 years ago
Solved

case statement not working as expected in power BI

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 ...
Need Help
Show and Tell
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    rocku2008_1985 

    you can try this

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

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

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)