Forum Discussion
I am receiving an error indication even though the initial indication is no syntax error.
let
startDate = DateTime.From([Start Date]),
createdOn = DateTime.From([Created On]),
totalDays = Duration.Days(startDate - createdOn),
totalWeekendDays = List.Sum(List.Transform({0..totalDays}, each if Date.DayOfWeek(Date.AddDays(createdOn, _)) >= 5 then 1 else 0)),
totalDurationHours = Duration.TotalHours(startDate - createdOn) - (totalWeekendDays * 24)
in
totalDurationHours
startDate = DateTime.From([Started]),
createdOn = DateTime.From([Created]),
totalDays = Duration.Days(startDate - createdOn),
totalWeekendDays = List.Sum(List.Transform({0..totalDays}, each if Date.DayOfWeek(Date.AddDays(createdOn, _)) >= 5 then 1 else 0)),
totalDurationHours = Duration.TotalHours(startDate - createdOn) - (totalWeekendDays * 24)
in
totalDurationHours
3 Replies
The error information indicates Start Date is not found. I use this column name in other queries with no trouble.
Thanks to all who took a look! I created my own trouble by renaming some columns along the way. Correcting accoringly solved the problem.
startDate = DateTime.From([Started]),
createdOn = DateTime.From([Created]),
totalDays = Duration.Days(startDate - createdOn),
totalWeekendDays = List.Sum(List.Transform({0..totalDays}, each if Date.DayOfWeek(Date.AddDays(createdOn, _)) >= 5 then 1 else 0)),
totalDurationHours = Duration.TotalHours(startDate - createdOn) - (totalWeekendDays * 24)
in
totalDurationHours