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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

making end date

Hello guys and girls men and woman,

i have a begin date colum this is a date format type and a colum with whole numbers that are hours of work so 3 is 3 hours of work how can i count the hours of work up to the begin date to make a end date 8 hours of work equals 1 workday

for example my startdate = 06-12-2022 and my work hours a 14 hours my end date must be 07-12-2022
my startdate only have date not time 

 

i hope someone can help me:))

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

Try adding a custom colum in the query editor with this formula (updated with your actual column names).

 

= [StartDate] + #duration(Number.RoundDown([HoursOfWork]/8,0),0,0,0)

 

Pat

Microsoft Employee

View solution in original post

1 REPLY 1
ppm1
Solution Sage
Solution Sage

Try adding a custom colum in the query editor with this formula (updated with your actual column names).

 

= [StartDate] + #duration(Number.RoundDown([HoursOfWork]/8,0),0,0,0)

 

Pat

Microsoft Employee

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors