Calculate expected delivery date without weekends

Anonymous — Fri, 07 May 2021 09:19:04 GMT

Helle everyone,

In Power Bi i need a column with the expected delivery date without counting weekends. Right now i have this in excel;

I have already managed to add the first four columns, but am having problems with the last column. In excel I used the following formula;
= workdays(order ready; average delivery time)
I just don't get this in power bi because there is no "workday" function. Does anyone know a solution for this, so --> order ready + interval = expected delivery date without weekends

thank you

Re: Calculate expected delivery date without weekends

Anonymous — Fri, 07 May 2021 11:04:50 GMT

Re: Calculate expected delivery date without weekends

Anonymous — Fri, 07 May 2021 12:49:07 GMT

Thank you so much! This works perfectly!

topic Re: Calculate expected delivery date without weekends in DAX Commands and Tips

Calculate expected delivery date without weekends

Re: Calculate expected delivery date without weekends

Re: Calculate expected delivery date without weekends