Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:))
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.