Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Expression.Error: 2 arguments were passed to a function which expects 3.

I've written a function that is intended to intake 2 arguments (dates) and report the number of weekdays elapsed. However, when I invoke the function, it tells me that my function is expecting 3 arguments. Why does Power Query tell me that the function expects 3 arguments?

 

---------------------------------------------------------------------------------------------------------

 

If I input a bogus 3rd argument, it tells me that the function is only looking for 2 arguments

  • Have you proved that the error does not come from the logic inside the function?

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    Have you proved that the error does not come from the logic inside the function?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Well, now I feel silly. That was the issue, thanks!

  • HotChilli's avatar
    HotChilli
    Community Champion

    Not my intention at all, just seemed worth investigating for starters.  Sometimes all it takes is another pair of eyes to look at something. 

    All the best.