Power Query - Function If Null

Name: Power Query - Function If Null
Uploaded: 2026-09-27T13:20:30+00:00
Duration: 21 min 18 s
Description: 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...

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?

Answer 1

Try

try input/1000 + 500 otherwise null

Answer 2

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

Power Query - Function If Null

2 Answers

Must Read

Your Answer

Chloe Bennett

Power Query - Function If Null

2 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

Chloe Bennett