Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
hrose1030
New Member

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

 

Annotation 2020-07-14 120635.png

 

 

 

 

 

 

hrose1030_1-1594742424136.png

FootEndDate = RELATED('Calendar'[StartToFoot])

 
 
 

 

Annotation 2020-07-14 120635.png
 
 
 
 

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 3
amitchandak
Super User
Super User

@hrose1030 , refer this blog can help

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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:

hrose1030_1-1594992696712.png

Mine:

hrose1030_2-1594992757799.png

 

I appreciate the help!

Greg_Deckler
Super User
Super User

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.