Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
The whole data is based on seconds, Still, I would like to convert the data to MM: SS. Below was the formula I used but the calculation is working and unfortunately, the data was not validating correctly.
Kindly do the needful please !
Solved! Go to Solution.
Hi, @Anonymous
In measure you cannot directly convert data to MM:SS.
You might consider using character ‘&’ to concatenate characters to get the final result
Please modify your original formula as below:
Response time in minutes =
VAR _duration =
AVERAGE ( CADD[Enter_to_Arrv_Seconds] )
VAR Hours =
INT ( _duration / 3600 )
VAR Minutes =
INT ( MOD ( _duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
ROUNDUP ( MOD ( MOD ( _duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
RETURN
Hours * 60 + Minutes & ":" & Seconds
Best Regards,
Community Support Team _ Eason
Hi @Anonymous
PLease try 'FORMAT" Dax function.
Refer below link;
https://docs.microsoft.com/en-us/dax/format-function-dax
Thanks,
Sanket
If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.
Hi, @Anonymous
In measure you cannot directly convert data to MM:SS.
You might consider using character ‘&’ to concatenate characters to get the final result
Please modify your original formula as below:
Response time in minutes =
VAR _duration =
AVERAGE ( CADD[Enter_to_Arrv_Seconds] )
VAR Hours =
INT ( _duration / 3600 )
VAR Minutes =
INT ( MOD ( _duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
ROUNDUP ( MOD ( MOD ( _duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
RETURN
Hours * 60 + Minutes & ":" & Seconds
Best Regards,
Community Support Team _ Eason
I'm looking the data validation side by doing the calculation based on the column i mentioned above,
@Anonymous , Hope it is number to time
New column = Quotient([Time in Second],60) & ":" & MOD([Time in Second],60)
or
TIme(Quotient([Time in Second],3600) ,Quotient(Mod([Time in Second],3600) ,60), Mod(Mod([Time in Second],3600) ,60) )
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
11 | |
10 | |
10 |