topic Adding workdays to a table with multiple dates in DAX Commands and Tips

Adding workdays to a table with multiple dates

hrose1030 — Tue, 14 Jul 2020 16:29:22 GMT

Hello,

I have a home construction schedule with different milestones which contain different dates per each house. I am trying to create a table which adds a set amount of workdays, based on milestones, to the start date, to get an end date. I want to use this as a template to be able to refresh my data. I created a calendar table with index and i have been able to get the first column of dates to go through the formulas and give me the correct "end date" column, but I need to figure out how to get it to parse through the columns each time...here is my current data table

FootEndDate = RELATED('Calendar'[StartToFoot])

So the FootToUnderslab column needs to add 10 workdays to the Pour Footing date column to get the FootEndDate column, the UnderslabTo Slab column needs to add 4 workdays to the Install underslab column to get the UnderslabEnd column, and so on. Any help is greatly appreciated!

It is difficult to explain exactly what i am doing so please let me know if you have any questions.

Thank you kindly

Re: Adding workdays to a table with multiple dates

Greg_Deckler — Tue, 14 Jul 2020 18:00:42 GMT

hrose1030 Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

That being said, seems like you might have a use for something like Net Work Days. https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109

Re: Adding workdays to a table with multiple dates

amitchandak — Tue, 14 Jul 2020 18:06:52 GMT

hrose1030 , refer this blog can help

https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766

Re: Adding workdays to a table with multiple dates

hrose1030 — Fri, 17 Jul 2020 13:33:41 GMT

Thank you, that post did help.

I have a different question now. I am working with the xViz Gantt chart and I can't seem to figure out how to customize the milestone markers. I've seen on a youtube tutorial a drop down menu for milestones but it doesn't show up on my visualization editor.

Tutorial:

Mine:

I appreciate the help!