Forum Discussion
Adding 1 weekday to date
Hi, Anonymous
If you want to add one day,please try calculated column as below:
New Date = IF ( 'Table'[Deal Type] IN { "DMT", "ABC" }, 'Table'[Date] + 1, 'Table'[Date] )If you want to add one working day,please try calculated column as below:
New Date2 = IF ( 'Table'[Deal Type] IN { "DMT", "ABC" }, SWITCH ( WEEKDAY ( 'Table'[Date], 2 ), 5, 'Table'[Date] + 3, 6, 'Table'[Date] + 2, 'Table'[Date] + 1 ), 'Table'[Date] )Please check my attached pbix file for more details.
If it doesn't meet your requirement ,please share your expected result in excel.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft EmployeeYou can adapt the approach in this video (M or DAX), just using 1 for the # of working days instead.
(5) Power BI - Tales from the Front #03 - Due Date From Working Days - YouTube
Pat
Great thank you, I'll take a look 🙂
- v-easonf-msft
Community Support
Hi, Anonymous
If you want to add one day,please try calculated column as below:
New Date = IF ( 'Table'[Deal Type] IN { "DMT", "ABC" }, 'Table'[Date] + 1, 'Table'[Date] )If you want to add one working day,please try calculated column as below:
New Date2 = IF ( 'Table'[Deal Type] IN { "DMT", "ABC" }, SWITCH ( WEEKDAY ( 'Table'[Date], 2 ), 5, 'Table'[Date] + 3, 6, 'Table'[Date] + 2, 'Table'[Date] + 1 ), 'Table'[Date] )Please check my attached pbix file for more details.
If it doesn't meet your requirement ,please share your expected result in excel.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.