The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |