Forum Discussion
Calculate Timesheet Hours (duration) and display by month using stacked column graph
Hi, I'm working with timesheet data pulled from Clockify. They already push through the "Interval duration", which is the employees daily time captured in hh:nn:ss. So we don't have to work t...
Please see this article and video. It is best to format your durations as a decimal (in days), do your calculations, and then format it at the end to display it in the format you'd like.
Calculate and Format Durations in DAX – Hoosier BI
Pat
ppm1 That worked. I've ended up adding an additional column, converting my duration to Hours.. and the graphs are working now. Thanks for the support