PQ Networkdays

[RattlingCarp3048]

I have created a new custom column with a simple (startdate - enddate)*24 then change the data type to decimal and round in order to calculate to hours like i need. in the custom column i tried the networkdays formula but that didnt work. i also found a custom function for creating your own networkdays function but that just gives me an error for all rows (pasted below). how do i exclude weekends and holidays??

**with 5/27/24 as a holiday** (startdate - enddate)*24

custom networkdays
(StartDate as date, EndDate as date, HolidayList as list) =>

let
DateList=List.Dates(StartDate,Number.From(EndDate-StartDate)+1,#duration(1,0,0,0)),
RemoveWeekends=List.Select(DateList, each Date.DayOfWeek(_,Day.Monday)<5),
RemoveHolidays=List.RemoveItems(RemoveWeekends, HolidayList),
CountDays=List.Count(RemoveHolidays)
in
CountDays

 

[alansidman]

Have you looked at this web page?

Date.Networkdays function for Power Query and Power BI

Today I'm going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function has 3 parameters: Start as date End as date optional holidays as list of dates The function comes with a UI that lets...

community.fabric.microsoft.com

 

[RattlingCarp3048]

Have you looked at this web page?

Date.Networkdays function for Power Query and Power BI

Today I'm going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function has 3 parameters: Start as date End as date optional holidays as list of dates The function comes with a UI that lets...

community.fabric.microsoft.com

not previously but the code they are using is extremely similar to what i am using. the only difference is they switched the order of removing weekends vs removing holiday's. I'll give their's a try....

 

[RattlingCarp3048]

Have you looked at this web page?

Date.Networkdays function for Power Query and Power BI

Today I'm going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function has 3 parameters: Start as date End as date optional holidays as list of dates The function comes with a UI that lets...

community.fabric.microsoft.com

Hello... i still get the same error as before. in the query code for networkdays all the examples shown the date is just a date. but for me all of mine are date/time. would that have anything to do with the error?