Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Grouping 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) Minutes = FORMAT(DATEDIFF('mCRM times'[fecha_inicial],'mCRM ti...
serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
3 years ago

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 !