Forum Discussion

paw1's avatar
paw1
Icon for Helper I rankHelper 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
paw1's avatar
paw1
Icon for Helper I rankHelper 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