How to find the difference between two date time columns and show the result as HH:MM:SS in a bar ch

[manoj_0911]

How to find the difference between two date time columns and show the result as HH:MM:SS in a bar chart (Attached Requirement)

REQUIREMENT 1 : TIME IN THE QUEUE FOR EACH CALL

REQUIREMENT 2 :  MAXIMUM WAIT TIME FOR EACH QUEUE

REQUIREMENT 3 :  AVERAGE WAITING TIME FOR EACH QUEUE

REQUIREMENT 4 :  TOTAL WAIT TIME FOR EACH QUEUE

WAITING TIME FORMULA:

DATASET:

ConversationId,QueueName,SkillList,StartDate
a8115f14-c64f-49a7-b695-b3dd601be5e1,ReportingIndia,reporting_skill_2,23-11-2022 17:05:55
db8c5cd9-bc61-4ae1-a47e-7ef9fdf58275,Pru_Annuities,reporting_skill_1,23-11-2022 17:10:06
188ddb5d-2184-4042-bcf9-5a118bdd24c5,PRU_Annuities_Sales,reporting_skill_2,23-11-2022 17:15:06
0e1397d1-fdce-49af-b705-be559107ae75,PRU_Annuities_RegionalMarket,reporting_skill_3,23-11-2022 17:20:06
ea34c3f3-70cf-4ecb-8beb-0e605546573d,QSSA,reporting_skill_4,23-11-2022 17:25:06
367cb474-61a5-4b05-8d54-df27c3d5a773,QSSA,reporting_skill_5,23-11-2022 17:30:06
7d105385-c37c-476c-9e70-ffa13b124587,QSSA,reporting_skill_6,23-11-2022 17:35:06
c6ee63a8-6f1d-4c93-bf60-93384dd754b9,ReportingIndia,reporting_skill_7,23-11-2022 17:40:06
6008b347-6abd-4df9-8f65-e9dbd6aecd84,ReportingIndia,reporting_skill_8,23-11-2022 17:45:05
c418edcf-80ec-4aef-9a53-b274ade67f75,ReportingIndia,reporting_skill_9,23-11-2022 17:50:02

[v-cgao-msft]

Hi @manoj_0911 ,

There was a little bit of difficulty. There are ways to convert the final calculation to a scalar of text type(h:mm:ss), but after testing it doesn't display properly when used as a value for a bar chart. My suggestion is to use DATEDIFF() to convert the time to decimal time (like14.56 hours) if you want.

You can also make suggestions here to help Desktop do a better job.

Ideas

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[manoj_0911]

Could you please attach here the workbook you used for reference?