Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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) )
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |