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
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.
Solved! Go to Solution.
you can try this
= Table.AddColumn(#"Changed Type", "Custom", each if [Format] = "Percentage" then [value]*100 else [value])
Proud to be a Super User!
you can try this
= Table.AddColumn(#"Changed Type", "Custom", each if [Format] = "Percentage" then [value]*100 else [value])
Proud to be a 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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |