How to add working days - formula not producing results

[swinings]

Good Morning wonderful people....please help....

I am trying to add working days (i.e. excluding holiday and weekends) to my power query so I can show some of our investigators what 20 working days is from their start date. I have scoured the internet and forums and found something that seemingly worked. However, now I'm stuck. My formula seems to be valid but it isn't providing me with results in the column.

I attached my screen with what I have been doing, and the formula I have.

What am I doing wrong?

TIA. Let me know if you need more from me!

[swinings]

I just got this to start working too. I essentially used a mix of the video and the code. I think it adds the extra day because, even though it started that day, it doesn't count as a working day. I'm not too concerned because I am using it as a created date. If it is a non work day, the investigator isn't going to "create" the investigation date because they aren't in anyway.

[TSP_PowerBi]

I am having the same issue. I got the days to come back but you will notice that it's adding an additonal day if start date is on a non working day.

[mahoneypat · Accepted solution]

Please see this video - (5) Power BI - Tales from the Front #03 - Due Date From Working Days - YouTube

Pat

[swinings]

I've been messing with this all afternoon. It doesn't take into consideration holiday's, just weekdays vs weekend. This has been the hardest part of figuring out the right code and I can't find it. Any thoughts to include holidays?