topic How to calculate final cutoff date (excluding weekends) in DAX Commands and Tips

How to calculate final cutoff date (excluding weekends)

48093 — Thu, 05 Mar 2020 04:41:07 GMT

Hi Team,

Can someone please help me to find solution for below problem in Power BI.

I have a order received date and no. of businesss days to deliver. I want calculate final cut off date(should not count weekends) based on received date and no. of business days. Basically I want calculate like "WORKDAY" function in excel.

I will be greafull can you guys provide a solution.

Re: How to calculate final cutoff date (excluding weekends)

Greg_Deckler — Thu, 05 Mar 2020 04:52:04 GMT

See if my Net Work Days quick measure helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/td-p/367362

Re: How to calculate final cutoff date (excluding weekends)

Anonymous — Thu, 05 Mar 2020 10:08:44 GMT

Hi 48093

I have provided solution in below link please check

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculating-Expected-Due-Completion-Date-Time-based-on-SLA-amp/m-p/925274#M9316

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.