Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |