Forum Discussion
sum of datediff
*sorry about the confusion, updated with a table. gate hours = DATEDIFF([min entered yard],[max exit yard],HOUR) i want to sum gate hour by week. however is taking the difference from [min en...
Hi Anonymous ,
Please use the following measure for gate hours:
gate hours new = SUMX(VALUES(Table[Dt]),DATEDIFF([min entered yard],[max exit yard],HOUR))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft
Community Support
Community SupportHi Anonymous ,
Please use the following measure for gate hours:
gate hours new = SUMX(VALUES(Table[Dt]),DATEDIFF([min entered yard],[max exit yard],HOUR))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai