Forum Discussion
Combining multiple excel and aggregate by category.
Hi, Anonymous ;
Is your duration displayed in PowerBI in the same hh: MM: SS format as in the picture?
If so, it is in text form, so the calculation result is incorrect and count of chart. You could check the Issues forum here:
https://stackoverflow.com/questions/62989953/how-to-find-total-duration-of-time-in-power-bi
https://stackoverflow.com/questions/52054319/show-time-duration-as-hhmmss-in-powerbi-charts
and can you share a simple data removing sensitive information, along with the results you want to output?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Anonymous ;
Is your duration displayed in PowerBI in the same hh: MM: SS format as in the picture?
If so, it is in text form, so the calculation result is incorrect and count of chart. You could check the Issues forum here:
https://stackoverflow.com/questions/62989953/how-to-find-total-duration-of-time-in-power-bi
https://stackoverflow.com/questions/52054319/show-time-duration-as-hhmmss-in-powerbi-charts
and can you share a simple data removing sensitive information, along with the results you want to output?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.