Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
Syndicate_Admin
Administrator
Administrator

¿Es posible cronometrar dinámicamente la duración en minutos si es superior a 60 segundos?

Tengo el requisito de mostrar la duración de la visita al sitio web. Con lo que estoy luchando es con cómo puedo mostrar el resultado de modo que si Average_Visit_Time < = 60 segundos, muestre "00 SEC", pero si Average_Visit_Time es > = 61 segundos, muestre "00:00 MIN: SEC".

Mis datos de medición y samle están a continuación.

Average_Visit_Time = PROMEDIO(MESA [VISIT_DURATION_SECONDS])
Visit_IDVisit_DateVISIT_DURATION_SECONDS
110/2/221130
210/1/221453
310/2/22433
410/4/22434
510/3/221130
610/3/221397
710/3/22107
810/2/221054
910/5/221388
1010/1/22250
1110/5/22748
1210/4/221213
1310/1/221417
1410/3/221441
1510/4/22650
1610/1/221106
1710/1/22750
1810/4/221470
1910/3/22565
2010/1/221144
2110/3/221239
2210/3/22430
2310/2/221435
2410/5/221400
2510/1/22557
2610/3/22955
2710/4/22632
2810/4/22419
2910/4/22732
3010/5/2251
1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Aquí hay algo para comenzar:

Measure = 
var TotalSeconds = AVERAGE('Table'[VISIT_DURATION_SECONDS])
var TotalMins = QUOTIENT(TotalSeconds, 60)
var remainderSeconds = MOD(TotalSeconds, 60)
return IF(TotalSeconds > 60, FORMAT(TotalMins, "##########") & ":" & FORMAT(remainderSeconds, "00"), TotalSeconds & " seconds")

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors