Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i have the following column duration in a table.
Duration |
3000 |
2000 |
4000 |
70000 |
13000 |
want following output
Mins:sec |
0.03 |
0.02 |
0.04 |
1.01 |
2.01 |
Solved! Go to Solution.
Hi @Anonymous
First i think you have a few errors with your raw data.
Instead of 13000 it should be 130,000 and the conversion will be 02:10 instead of 2.01
Same for 70000. It needs to be 01:10.
Please see workspace with the conversion on this link.
You need to create the following 2 calculated columns:
Duration New = 'Table'[Duration] * 0.001 // Conversion from milliseconds to seconds
Conversion = VAR Minutes = INT ( 'Table'[Duration New] / 60) VAR Seconds = ROUNDUP(MOD ( 'Table'[Duration New], 60 ),0) // We round up here to get a whole number VAR M = IF ( LEN ( Minutes ) = 1, CONCATENATE ( "0", Minutes ), CONCATENATE ( "", Minutes ) ) // Seconds with leading zeros VAR S = IF ( LEN ( Seconds ) = 1, CONCATENATE ( "0", Seconds ), CONCATENATE ( "", Seconds ) ) RETURN CONCATENATE(CONCATENATE(M, ":"), S)
Hi @Anonymous
First i think you have a few errors with your raw data.
Instead of 13000 it should be 130,000 and the conversion will be 02:10 instead of 2.01
Same for 70000. It needs to be 01:10.
Please see workspace with the conversion on this link.
You need to create the following 2 calculated columns:
Duration New = 'Table'[Duration] * 0.001 // Conversion from milliseconds to seconds
Conversion = VAR Minutes = INT ( 'Table'[Duration New] / 60) VAR Seconds = ROUNDUP(MOD ( 'Table'[Duration New], 60 ),0) // We round up here to get a whole number VAR M = IF ( LEN ( Minutes ) = 1, CONCATENATE ( "0", Minutes ), CONCATENATE ( "", Minutes ) ) // Seconds with leading zeros VAR S = IF ( LEN ( Seconds ) = 1, CONCATENATE ( "0", Seconds ), CONCATENATE ( "", Seconds ) ) RETURN CONCATENATE(CONCATENATE(M, ":"), S)
want to show in a bar chart employe wise call duration
when i was sum the conversion column its not give expected output in a chart
How to change it to mins:sec and what is modelling tab?
can you please explain, this would be helpful, really.
Thanks @themistoklis
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |