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