Forum Discussion
Adding workdays to a table with multiple dates
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
3 Replies
- Greg_Deckler
Community Champion
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
- amitchandak
Super User
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!
