topic Re: I am working on removing Holidays from a workday formula in DAX Commands and Tips

I am working on removing Holidays from a workday formula

Anonymous — Mon, 03 Oct 2022 18:41:21 GMT

I am working on a calendar and I dont want weekends or holidays as seen below.

Re: I am working on removing Holidays from a workday formula

Greg_Deckler — Mon, 03 Oct 2022 18:48:33 GMT

Anonymous NETWORKDAYS NETWORKDAYS function (DAX) - DAX | Microsoft Learn

Re: I am working on removing Holidays from a workday formula

Anonymous — Mon, 03 Oct 2022 18:56:53 GMT

That is not working for what I need. I have a column that has total training days.

Re: I am working on removing Holidays from a workday formula

Greg_Deckler — Mon, 03 Oct 2022 19:12:59 GMT

Anonymous Well, I had a Holidays version in the old school way of doing it:

Net Work Days - Microsoft Power BI Community

Re: I am working on removing Holidays from a workday formula

Anonymous — Tue, 04 Oct 2022 09:04:56 GMT

Hi Anonymous

Extracting weekdays from Calendar date is easy, you just need to do it with WEEKDAY() . But for each country, their holiday is different , you need to remove it manually . Taking Chinese New Year's Day as a column, I created a sample .

In China , the New Year's Day are "2022-01-01", "2022-01-02", "2022-01-03" , at the same time "2022-01-01", "2022-01-02" are the weekend , so in the workdays column , the return value does not include the above three dates .

Create a calculated column like below :

WorkDate = var _daynumber= WEEKDAY('Table'[Date],2) var _holiday=DATESBETWEEN('Table'[Date],"2022-01-01","2022-01-03") return if( _daynumber = 6 || _daynumber=7 || 'Table'[Date] in _holiday, BLANK(),'Table'[Date])

The result is shown as below :

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: I am working on removing Holidays from a workday formula

Anonymous — Fri, 07 Oct 2022 14:46:57 GMT

Anonymous and Greg_Deckler

Those two formulas are not working can you think of anything else.

So what I need is I have a table that has employee start dates and total training days based on curriculum. I need to know the end of training date without holidays or weekends. for example a training class started on 8/15/2022 and it last 24 working days I need to know what the date that training will end on.

thanks,

Re: I am working on removing Holidays from a workday formula

Anonymous — Thu, 13 Oct 2022 02:49:21 GMT

Hi Anonymous

In order to provide an accurate formula , hopefully you can provide your sample in the format of a table or pbix file .

Best Regards,
Community Support Team _ Ailsa Tao