Forum Discussion
AdministratorGrouping by field text
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)
Thank you.
8 Replies
- serpiva64
Solution Sage
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 !
Syndicate_AdminHello
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.
- 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
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
ok
Finally I have passed everything to seconds and from there I have calculated the hours, minutes and seconds.
Thanks a lot.
