Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply

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:

percentage-conversion_ssms.PNG

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.

casesql_BI.PNG

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@rocku2008_1985 

you can try this

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

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ryan_mayu
Super User
Super User

@rocku2008_1985 

you can try this

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

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




vicky_
Super User
Super User

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)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.