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!View all the Fabric Data Days sessions on demand. View schedule
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.
| Visit_ID | Visit_Date | VISIT_DURATION_SECONDS |
| 1 | 10/2/22 | 1130 |
| 2 | 10/1/22 | 1453 |
| 3 | 10/2/22 | 433 |
| 4 | 10/4/22 | 434 |
| 5 | 10/3/22 | 1130 |
| 6 | 10/3/22 | 1397 |
| 7 | 10/3/22 | 107 |
| 8 | 10/2/22 | 1054 |
| 9 | 10/5/22 | 1388 |
| 10 | 10/1/22 | 250 |
| 11 | 10/5/22 | 748 |
| 12 | 10/4/22 | 1213 |
| 13 | 10/1/22 | 1417 |
| 14 | 10/3/22 | 1441 |
| 15 | 10/4/22 | 650 |
| 16 | 10/1/22 | 1106 |
| 17 | 10/1/22 | 750 |
| 18 | 10/4/22 | 1470 |
| 19 | 10/3/22 | 565 |
| 20 | 10/1/22 | 1144 |
| 21 | 10/3/22 | 1239 |
| 22 | 10/3/22 | 430 |
| 23 | 10/2/22 | 1435 |
| 24 | 10/5/22 | 1400 |
| 25 | 10/1/22 | 557 |
| 26 | 10/3/22 | 955 |
| 27 | 10/4/22 | 632 |
| 28 | 10/4/22 | 419 |
| 29 | 10/4/22 | 732 |
| 30 | 10/5/22 | 51 |
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")
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!