Forum Discussion

Snowy34's avatar
Snowy34
Helper III
4 years ago
Solved

Time Duration visual

Happy New Year BI Community!!!   OK this one is killing me right now, I'm trying to plot a simpel grapth that shows total time spent in hours per month. I have a table that shows me this per ticket...
Need Help
Tutorial Requests
parry2k's avatar
parry2k
Super User
4 years ago

Snowy34 you need to convert days into hours

 

Measure = 
VAR __value = [Your Value]
VAR __days = INT ( __value )
VAR __hours = ( __value - __days ) * 100
RETURN
__hours + ( __days * 60 )

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • Snowy34's avatar
    Snowy34
    Helper III
    4 years ago

    Thank you for that but seems wrong.

     

    If we look at ticket 221458 its 1 day 52 hours and 59 seconds but the new measure is saying 64 hours should it be 24.8830556?

    dETYW9A.png (2148×453) (imgur.com)