Forum Discussion
Calculate 10 Working Days after Date
Hi Community,
Stuck with some logic inside Power BI,Need your help!!
I have date called PTR in my data.
I need to calculate 10 working days after PTR excluding Sat and Sun and public Holidays.I also have Public holiday dates stored in a different table.So the The new date after 10 days should neither be a Sat,Sun or public holiday.
For eg-
PTR=>15th Jan 2024 so
10 working days after PTR should be 26th Jan 2024 since 26th Jan 2024 is marked as public holiday in Holiday Table(Friday) so it should give me the result 29th Jan 2024(Monday).I have attached data for reference.
Holiday Dates
| 25 December 2024 |
| 01 November 2024 |
| 31 October 2024 |
| 02 October 2024 |
| 19 August 2024 |
| 15 August 2024 |
| 17 June 2024 |
| 25 March 2024 |
| 26 January 2024 |
| 01 January 2024 |
| Planned TR Date |
| 03-May-24 |
| 21-Jun-24 |
| 12-Jul-24 |
| 27-Feb-24 |
| 15-Mar-24 |
| 25-Mar-24 |
| 25-Mar-24 |
| 29-Mar-24 |
| 29-Mar-24 |
| 03-Apr-24 |
| 11-Apr-24 |
| 11-Apr-24 |
| 12-Apr-24 |
| 12-Apr-24 |
| 19-Apr-24 |
| 26-Apr-24 |
| 26-Apr-24 |
| 30-Apr-24 |
| 30-Apr-24 |
| 07-May-24 |
| 14-May-24 |
| 14-May-24 |
| 15-May-24 |
| 17-May-24 |
| 21-May-24 |
| 22-May-24 |
| 24-May-24 |
| 27-May-24 |
| 29-May-24 |
| 29-May-24 |
| 03-Jun-24 |
| 03-Jun-24 |
| 05-Jun-24 |
| 06-Jun-24 |
| 10-Jun-24 |
| 10-Jun-24 |
| 21-Jun-24 |
| 24-Jun-24 |
| 24-Jun-24 |
| 03-Jul-24 |
| 08-Jul-24 |
| 15-Jul-24 |
| 19-Jul-24 |
| 22-Jul-24 |
| 29-Jul-24 |
| 29-Jul-24 |
| 09-Aug-24 |
| 27-Aug-24 |
| 13-Sep-24 |
| 19-Sep-24 |
| 27-Sep-24 |
| 28-Sep-24 |
| 09-Jan-24 |
| 17-Jan-24 |
| 06-Feb-24 |
| 20-Feb-24 |
| 05-Mar-24 |
| 22-Mar-24 |
| 09-Apr-24 |
| 11-Apr-24 |
| 25-Apr-24 |
| 21-May-24 |
| 24-May-24 |
| 06-Jun-24 |
| 06-Jun-24 |
| 24-Jun-24 |
| 15-Jul-24 |
| 18-Jul-24 |
| 26-Jul-24 |
| 16-Aug-24 |
| 23-Aug-24 |
| 20-Sep-24 |
| 27-Sep-24 |
| 02-Jan-24 |
| 05-Jan-24 |
| 08-Jan-24 |
| 09-Jan-24 |
| 09-Jan-24 |
| 10-Jan-24 |
| 12-Jan-24 |
| 12-Jan-24 |
| 15-Jan-24 |
| 15-Jan-24 |
| 16-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 24-Jan-24 |
| 25-Jan-24 |
| 26-Jan-24 |
| 01-Feb-24 |
| 01-Feb-24 |
| 02-Feb-24 |
| 02-Feb-24 |
| 12-Feb-24 |
| 12-Feb-24 |
| 13-Feb-24 |
| 16-Feb-24 |
| 27-Feb-24 |
| 08-Mar-24 |
| 14-Mar-24 |
| 21-Mar-24 |
| 21-Mar-24 |
| 26-Mar-24 |
| 12-Apr-24 |
| 06-May-24 |
| 16-May-24 |
| 03-Jun-24 |
| 24-Jun-24 |
| 25-Jun-24 |
| 05-Jul-24 |
| 11-Jul-24 |
| 15-Jul-24 |
| 18-Jul-24 |
| 25-Jul-24 |
| 02-Aug-24 |
| 09-Aug-24 |
| 22-Jan-24 |
| 08-Feb-24 |
| 12-Feb-24 |
| 13-Feb-24 |
| 26-Feb-24 |
| 28-Feb-24 |
| 10-Jun-24 |
| 02-Aug-24 |
| 09-Jan-24 |
| 16-Jan-24 |
| 16-Jan-24 |
| 17-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 23-Jan-24 |
| 25-Jan-24 |
| 29-Jan-24 |
| 29-Jan-24 |
| 30-Jan-24 |
| 31-Jan-24 |
| 02-Feb-24 |
| 09-Feb-24 |
| 09-Feb-24 |
| 19-Feb-24 |
| 20-Feb-24 |
| 23-Feb-24 |
| 05-Mar-24 |
| 06-Mar-24 |
| 15-Mar-24 |
| 21-Mar-24 |
| 22-Mar-24 |
| 28-Mar-24 |
| 29-Mar-24 |
| 29-Mar-24 |
| 02-Apr-24 |
| 05-Apr-24 |
| 19-Apr-24 |
| 24-Apr-24 |
| 13-May-24 |
| 23-May-24 |
| 27-May-24 |
| 01-Jul-24 |
| 02-Jul-24 |
| 10-Jul-24 |
| 22-Jul-24 |
| 24-Jul-24 |
| Planned TR Date |
| 03-May-24 |
| 21-Jun-24 |
| 12-Jul-24 |
| 27-Feb-24 |
| 15-Mar-24 |
| 25-Mar-24 |
| 25-Mar-24 |
| 29-Mar-24 |
| 29-Mar-24 |
| 03-Apr-24 |
| 11-Apr-24 |
| 11-Apr-24 |
| 12-Apr-24 |
| 12-Apr-24 |
| 19-Apr-24 |
| 26-Apr-24 |
| 26-Apr-24 |
| 30-Apr-24 |
| 30-Apr-24 |
| 07-May-24 |
| 14-May-24 |
| 14-May-24 |
| 15-May-24 |
| 17-May-24 |
| 21-May-24 |
| 22-May-24 |
| 24-May-24 |
| 27-May-24 |
| 29-May-24 |
| 29-May-24 |
| 03-Jun-24 |
| 03-Jun-24 |
| 05-Jun-24 |
| 06-Jun-24 |
| 10-Jun-24 |
| 10-Jun-24 |
| 21-Jun-24 |
| 24-Jun-24 |
| 24-Jun-24 |
| 03-Jul-24 |
| 08-Jul-24 |
| 15-Jul-24 |
| 19-Jul-24 |
| 22-Jul-24 |
| 29-Jul-24 |
| 29-Jul-24 |
| 09-Aug-24 |
| 27-Aug-24 |
| 13-Sep-24 |
| 19-Sep-24 |
| 27-Sep-24 |
| 28-Sep-24 |
| 09-Jan-24 |
| 17-Jan-24 |
| 06-Feb-24 |
| 20-Feb-24 |
| 05-Mar-24 |
| 22-Mar-24 |
| 09-Apr-24 |
| 11-Apr-24 |
| 25-Apr-24 |
| 21-May-24 |
| 24-May-24 |
| 06-Jun-24 |
| 06-Jun-24 |
| 24-Jun-24 |
| 15-Jul-24 |
| 18-Jul-24 |
| 26-Jul-24 |
| 16-Aug-24 |
| 23-Aug-24 |
| 20-Sep-24 |
| 27-Sep-24 |
| 02-Jan-24 |
| 05-Jan-24 |
| 08-Jan-24 |
| 09-Jan-24 |
| 09-Jan-24 |
| 10-Jan-24 |
| 12-Jan-24 |
| 12-Jan-24 |
| 15-Jan-24 |
| 15-Jan-24 |
| 16-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 24-Jan-24 |
| 25-Jan-24 |
| 26-Jan-24 |
| 01-Feb-24 |
| 01-Feb-24 |
| 02-Feb-24 |
| 02-Feb-24 |
| 12-Feb-24 |
| 12-Feb-24 |
| 13-Feb-24 |
| 16-Feb-24 |
| 27-Feb-24 |
| 08-Mar-24 |
| 14-Mar-24 |
| 21-Mar-24 |
| 21-Mar-24 |
| 26-Mar-24 |
| 12-Apr-24 |
| 06-May-24 |
| 16-May-24 |
| 03-Jun-24 |
| 24-Jun-24 |
| 25-Jun-24 |
| 05-Jul-24 |
| 11-Jul-24 |
| 15-Jul-24 |
| 18-Jul-24 |
| 25-Jul-24 |
| 02-Aug-24 |
| 09-Aug-24 |
| 22-Jan-24 |
| 08-Feb-24 |
| 12-Feb-24 |
| 13-Feb-24 |
| 26-Feb-24 |
| 28-Feb-24 |
| 10-Jun-24 |
| 02-Aug-24 |
| 09-Jan-24 |
| 16-Jan-24 |
| 16-Jan-24 |
| 17-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 19-Jan-24 |
| 23-Jan-24 |
| 25-Jan-24 |
| 29-Jan-24 |
| 29-Jan-24 |
| 30-Jan-24 |
| 31-Jan-24 |
| 02-Feb-24 |
| 09-Feb-24 |
| 09-Feb-24 |
| 19-Feb-24 |
| 20-Feb-24 |
| 23-Feb-24 |
| 05-Mar-24 |
| 06-Mar-24 |
| 15-Mar-24 |
| 21-Mar-24 |
| 22-Mar-24 |
| 28-Mar-24 |
| 29-Mar-24 |
| 29-Mar-24 |
| 02-Apr-24 |
| 05-Apr-24 |
| 19-Apr-24 |
| 24-Apr-24 |
| 13-May-24 |
| 23-May-24 |
| 27-May-24 |
| 01-Jul-24 |
| 02-Jul-24 |
| 10-Jul-24 |
| 22-Jul-24 |
| 24-Jul-24 |
| 01-Aug-24 |
| 20-Aug-24 |
