Grouping by field text

[Syndicate_Admin]

Hello

Can you add the minutes of the same code? In the table I have Codes column (text field) and Minutes column (also text field)

Minutes = FORMAT(DATEDIFF('mCRM times'[fecha_inicial],'mCRM times'[fecha_final],MINUTE) /60 /24,"hh:mm")

Thank you.

[Syndicate_Admin]

ok

Finally I have passed everything to seconds and from there I have calculated the hours, minutes and seconds.

Thanks a lot.

[Syndicate_Admin]

Wow, how strange that nothing can be done about it because I think it is quite normal to make use of the total elapsed time, which is greater than 24 hours of course.

Or to tell you the hours instead of minutes... After you can always spend minutes I understand..

[serpiva64]

You can always keep your data in hours or minutes

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Syndicate_Admin]

Yes, it is indeed more than one day, it should leave 70h approx

If one day passes, does it no longer add you correctly?

[serpiva64]

No, it adds correctly but in your format the max of hours are 24 (a day).

see examples 1 and 2:

[Syndicate_Admin]

Hello

I'm testing the measure and it seems to work in part, if you look at the capture, in the second table where there is interlocutor and minutes, only adding the last rows already add more than 3h but in the table on the left, only adds 1h and 3m

The formula for Minutes in the second table is

Minutes = FORMAT(DATEDIFF('mCRM times'[fecha_inicial],'mCRM times'[fecha_final],MINUTE) /60/24,"hh:mm")

Do you know what may be happening?

[serpiva64]

Maybe the sum of 1361 is more then 1 day.  

[serpiva64]

Hi,

you can use a measure

Measure1 = FORMAT(SUMX('Table', DATEDIFF('Table'[Initial], 'Table'[Final], MINUTE)/60/24), "hh:mm")

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !