Forum Discussion
Solved
Power Query Custom Function with IF statement
I made the custom function below in Power query, but results are not what I expect. If I put in 0.1 I get 50 instead of 0, for instance. Must be some stupid mistake or misunderstanding on my part, ca...
It works correctly
function is
(vGrowth as number) => let result = if vGrowth > 1 then 100 else if vGrowth > 0.5 then 50 else if vGrowth > 0.2 then 20 else if vGrowth > -0.2 then 0 else if vGrowth > -0.5 then -20 else if vGrowth > -1 then -50 else -100 in result
It works correctly
function is
(vGrowth as number) =>
let result =
if vGrowth > 1 then 100
else if vGrowth > 0.5 then 50
else if vGrowth > 0.2 then 20
else if vGrowth > -0.2 then 0
else if vGrowth > -0.5 then -20
else if vGrowth > -1 then -50
else -100
in result
Yes, it does for me now too, very odd. Should've taken a screenshot. When I invoked the function, I got strange results. Thanks for looking into it...