Need Start to end date total hours(DAX)

[Anonymous]

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

[lbendlin]

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.

[Anonymous]

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

[lbendlin · Accepted solution]

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