Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |