Forum Discussion
Solved
Total Duration calculation in DAX
Hi, Please can you help me to calculate Total Duration(Completed-Started) in days hh:mm:sss format aggregated by Department and ID in Dax only. In my reprot Department, ID is coming from one table a...
check solution
https://dropmefiles.com/6fcgE
Hello paw1 ,
check if this function would help for your case https://learn.microsoft.com/en-us/dax/datediff-function-dax
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
hi Date difference function sytnax contains any one parameter like hour/minute/second. But i am looking for days hh:mm:ss format and also need to aggregate by Department and id
