Power Query - Function IF null

Question

I have a specific function in Power Query like this:

let Func_Test = (input) =>
    input/1000 + 500
in
    Func_Test

The challange is now, that the input can contain null. If this is the case, then I get an error. How can I avoid this directly in the function?

What is the error? I cannot reproduce your problem. If I input null, the result is null. Please provide sufficient information so I can reproduce your problem. — Ron Rosenfeld
– Ron Rosenfeld, Commented Jan 23, 2022 at 21:34

horseyride · Accepted Answer · 2022-01-23 22:14:15Z

1

Try

try input/1000 + 500 otherwise null

answered Jan 23, 2022 at 22:14

horseyride

21.8k3 gold badges15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ron Rosenfeld · Accepted Answer · 2022-01-24 01:07:05Z

1

If I input null into your function, I get null as a response.

However if I don't input anything, the response is an error message :Expression.Error: 0 arguments were passed to a function which expects 1.

For this latter problem, just make the argument optional:

let Func_Test = (optional input) =>
    input/1000 + 500
in
    Func_Test

answered Jan 24, 2022 at 1:07

Ron Rosenfeld

62k7 gold badges35 silver badges71 bronze badges