convert decimal format into minutes and seconds format

[vat2do]

Hi experts,

i am using power bi desktop, i have a table in decimal format as shown below:

ASA		Avg Wait		Avg Handle		Avg Talk		Avg ACW
11821.5		11821.5		276419.1667		187018.6667		73000
10408.18182		10408.18182		303240.65		340380.1875		21750

i want output in duration as below:

ASA		Avg Wait		Avg Handle		Avg Talk		Avg ACW
12s		12s		4m 36s		3m 7s		1m 13s
10s		10s		5m 3s		5m 40s		22s

Appreciate your support.

Regards,

[Anonymous]

Hi @vat2do ,

I have created a simple sample, please refer to it to see if it helps you.

Create  measures.

acm =
VAR _acm =
    MAX ( 'Table'[Avg ACW] )
VAR _second =
    DIVIDE ( _acm, 1000 )
VAR _b =
    ROUND ( MOD ( _second, 60 ), 0 )
VAR _c =
    ROUND ( QUOTIENT ( _second, 60 ), 0 )
VAR _1re = _c & "m" & _b & "s"
RETURN
    IF ( _c = 0, _b & "s", _1re )

asa_ =
VAR _secone =
    MAX ( 'Table'[ASA] )
VAR _m =
    ROUND ( DIVIDE ( _secone, 1000 ), 0 )
RETURN
    _m & "s"

 I have also use columns, please refer to.

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vat2do · Accepted solution]

Thanks a lot, its working perfectly.