- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Replicating WORKDAY formula with holidays per country
Dear Community,
My name is Borja and I am currently working as a BI specialist in one european logistics company (which I prefer to not mention).
Basically, we have sold some logistic services to a customer, and we have a signed SLA agreement with the customer depending on the country. What I am trying to build is a column that gives me the Guaranteed Delivery Date for the parcels depending on when they were processed and where are they going to.
For example lets assume a parcel processed on January 23th going to UK has a SLA of 4 days. This means it should be delivered in 4 working days, therefore the Guaranteed Delivery Date should be January 29th.
The first problem I am facing is how to ignore weekends, in Excel I use WORKDAY formula but this doesn't exist in Power BI.
My second issue is how to also take into account bank holidays per country. In Excel we use a FILTER formula so it only adds the bank holidays for the destination country.
Oue formula looks like this =WORKDAY(K2,Y2,FILTER(Holidays!A1:X27, Holidays!A1:X1=E2))
Column K is the Processed date.
Column Y is the agreed SLA.
Holidays!A1:X27 is the sheet with all the holidays per country.
Column E is the country.
Does anyone knows how to build this in PowerBI?
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The equivalent function in PowerBI is networkdays: https://learn.microsoft.com/en-us/dax/networkdays-dax
you'll need another table of dates with the holidays per country to pass a the final argument to the function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vicky,
Thanks for your kind answer.
As far as I know, NETWORKDAYS will give you the number of working days between two days, and what I need is to get the resulting date after adding X working days to a date.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-08-2024 04:08 AM | |||
01-08-2025 01:10 AM | |||
07-12-2024 05:21 AM | |||
10-23-2024 09:49 AM | |||
01-30-2025 05:01 AM |
User | Count |
---|---|
14 | |
13 | |
11 | |
10 | |
8 |