Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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!
@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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |