Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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?

 

fxWeekdaysElapsed.png

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

InvokedFunction.png

 

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

InvokedFunction2.png

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

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

View solution in original post

3 REPLIES 3
HotChilli
Super User
Super User

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.

Anonymous
Not applicable

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

HotChilli
Super User
Super User

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.