Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |