Forum Discussion
Prathyusika
3 years agoFrequent Visitor
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