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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
Thank you so much! This works perfectly!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 14 | |
| 5 | |
| 4 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 25 | |
| 10 | |
| 10 | |
| 6 | |
| 6 |