Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate expected delivery date without weekends

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you so much! This works perfectly!