Forum Discussion
ConnieMaldonado
Responsive Resident
Responsive ResidentEXCLUDE certain amounts in calculation
I have the data below and am calculating efficiency rates for technicians performing various services onsite in customers' homes. The efficiency is calculated as: EXPECTED Duration / ACTUAL Dur...
maybe you can try this to create a new column
Column = DATEDIFF('Table'[GEOFENCE Arrive Time],'Table'[GEOFENCE Depart Time],MINUTE)/CALCULATE(count('Table'[Work Order ID]),ALLEXCEPT('Table','Table'[Work Order ID]))
ConnieMaldonadoResponsive Resident
Responsive ResidentThis works - thanks very much!
ryan_mayu
Super User
Super Useryou are welcome