Forum Discussion

paw1's avatar
paw1
Helper I
3 years ago
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...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

can show what result you expect

paw1's avatar
paw1
Helper I
3 years ago

Hi .

I am expecting below Total duration as expected output then it need to sum at department and id level

 

DepartmentIDTotal Duration 
Clothes2031 day 00:33:28
Electronics2062 day 00:00:00
Electronics2071 day 02:00:00

 

 

DepartmentIDCompetedStartedTotal Duration 
Clothes20331/01/2023 14:45:1530/01/2023 14:12:151 day 00:33:00
Clothes20319/12/2022 09:57:5819/12/2022 09:57:300 day 00:00:28
Electronics20621/12/2022 10:57:5819/12/2022 10:57:582 day 00:00:00
Electronics20722/12/2022 10:57:5821/12/2022 10:57:581 day 00:00:00
Electronics20726/12/2022 12:57:5826/12/2022 10:57:580 day 02:00:00
    • paw1's avatar
      paw1
      Helper I
      3 years ago

      Hi Ahmedx,

      Thanks for you reply. I need aggregate of Total Duration by Department and ID. For example in above ooutput

       

      for Clothes Department Total duration need to show like 1 day 01:33:28 . its sum of two entries in front end table