Hi Mr. Excel,
I use the "WORKDAY" formula in excel to identify the correct dispatch date after creation of order - being 1D to load the goods. So if we key an order on Friday we'd expect it to be dispatched on Monday (not over the weekends).Which would be represented by below table. When using Power BI the "WORKDAY" formula doesn't exist and NETWORKDAY formula doesn't work. Could you help me to identify a new formula in Power BI to replace WORKDAY? Thanks!!
I use the "WORKDAY" formula in excel to identify the correct dispatch date after creation of order - being 1D to load the goods. So if we key an order on Friday we'd expect it to be dispatched on Monday (not over the weekends).Which would be represented by below table. When using Power BI the "WORKDAY" formula doesn't exist and NETWORKDAY formula doesn't work. Could you help me to identify a new formula in Power BI to replace WORKDAY? Thanks!!
| Created on | Expected PGI Date |
| 3/07/2023 | 4/07/2023 |
| 7/07/2023 | 10/07/2023 |
| 7/07/2023 | 10/07/2023 |
