Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Anonymous
Not applicable

Need Help in finding Due date

Hi Everyone,

 

I am new to this portal,

I need help in finding dates. I have ticket received dates,  I want to add 10 days to it, but if there is weekends or holidays within this 10 days then need to extend the due date by that many days 

 

Ticket reveived: 4thJuly 2022

business days: 10 days

Due date: 13 July 2022 but if there is a weekend on 9th and 10th July. 

Result i want : 15th July 2022 instead of 13th July 2022

 

I tried Workday function in Excel. I dont know the logic to apply in DAX.