topic Re: Need Start to end date total hours(DAX) in DAX Commands and Tips

Need Start to end date total hours(DAX)

Anonymous — Fri, 06 Aug 2021 12:35:35 GMT

Hi All,
As per the screenshot, I want the total hours based on start to completion date (Note:- some of the completion dates are not available that time take the current date, and also weekends are not counted like Saturday, Sunday)
If anybody knows, please help me. Thanks

Re: Need Start to end date total hours(DAX)

lbendlin — Sun, 08 Aug 2021 03:17:42 GMT

INT((COALESCE([Completion Date],NOW())-[Start Date))*24)

Excluding weekend days adds a lot (A LOT) of complexity. You need to define what should happen when the start date or the completion date fall on a weekend day.

Re: Need Start to end date total hours(DAX)

Anonymous — Mon, 09 Aug 2021 05:19:47 GMT

Thanks for sharing the information, But It's showing an error message. (Note:- I remove the last two Brackets)

Re: Need Start to end date total hours(DAX)

lbendlin — Mon, 09 Aug 2021 13:11:23 GMT

INT((COALESCE([Completion Date],NOW())-[Start Date]*24)