Forum Discussion

Prathyusika's avatar
Prathyusika
Frequent Visitor
3 years ago

undefined


IF SUM([WFM_duration (copy)]) % 3600 > 3570 AND SUM([WFM_duration (copy)]) % 3600 != 3600 THEN // rounding anything from 59:30 to next hour
100
ELSE
IIF(SUM([WFM_duration (copy)]) % 60 >= 30 AND SUM([WFM_duration (copy)]) % 60 != 60,1,0) // seconds
+ IIF(INT(SUM([WFM_duration (copy)])/60) %60 == 60, 0, INT(SUM([WFM_duration (copy)])/60) %60) // minutes
END
+ INT(SUM([WFM_duration (copy)])/3600) * 100  how to convert tableau calculation to power bi i need HH:MM:SS format and i want to aggregate the hours consumed

No RepliesBe the first to reply