Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
(Created as date, Closed as date, Holiday as list) as number => let ListDates = List.Dates (Created, Number.From (Closed-Created), #duration(1,0,0,0)), RemoveWeekends = List.Select(ListDates, each Date.DayOfWeek(_, Day.Monday)< 5), RemoveHolidays = List.RemoveItems (RemoveWeekends,Holiday), CountDays=List.Count(RemoveHolidays) in CountDays
It has returned an error saying:
Expression.Error: 2 arguments were passed to a function which expects 3. Details: Pattern= Arguments=[List]
Can anyone help me pinpoint what this error means and where I may have messed up the query?
Hello - when I invoke the function I don't get an error. Your function has three required arguments, so three must be entered when the function is invoked, like the snip below. From the error message, it looks like perhaps a list of holiday dates is not be included.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 7 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 22 | |
| 14 | |
| 11 | |
| 10 | |
| 9 |