Forum Discussion

Kopek's avatar
Kopek
Helper IV
8 years ago
Solved

Count task duration with Working days, hours and miuntes

Hello, I would like to count duration of each task. The working days only should be counted. What's more counting on full days is not enough, I should count duration in working days including hours ...
Need Help
  • Kopek's avatar
    Kopek
    8 years ago
    , exactly :)

    Thank you all for your answers, Anonymous I have not had chance to check your second solution , but I found exactly what I need under this link , https://youtu.be/GLIoDbOiJgw, so if you have similar problem in the future, I highly recommend it.

    Thanks a lot !:)
Kopek's avatar
Kopek
Helper IV
8 years ago

Hello Anonymous,

 

Thanks for your help!

 

Unfortunaltely something seems to be wrong in the formula, the problem starts when [days] has to be added to the formula. Can you let me know where from [dates] are taken? is it column I suppose to have ? 

Or has it to be created  from sratch?  (I am attaching formula shreenshot)

DatesDuration = ADDCOLUMNS(SELECTCOLUMNS(GENERATE(incidents,FILTER(ALLNOBLANKROW('Calendar'),AND('Calendar'[Date]>=incidents[Opened].[Date],'Calendar'[Date]<=incidents[Resolved].[Date]))),"open",incidents[Opened],"resolve",incidents[Resolved],"days",'Calendar'[Date],"weekday",'Calendar'[Column],"duration",IF(FORMAT(incidents[Opened],"short date")=FORMAT(incidents[Resolved],"short date",incidents[Resolved]-incidents[Opened],IF(FORMAT([days], "Short Date")=FORMAT(incidents[Opened], Short Date", [days]+1-incidents[opened], IF (FORMAT [days], "Short Date")=FORMAT(incidents[Resolved], "Short Date"), incidents[Resolved]-[days],1))))

Kopek's avatar
Kopek
Helper IV
8 years ago

Anonymous I found out, that "Days" coulm I created in the measure, I have corrected the measure accordingly, but unfortunately I have received wrong message :  "The Expression Refers to multiple columns. Multiple columns cannot be converted to a scalar value"

 

 

 

are you able to help with this ?

 

Thanks in advance.