buenas soy nuevo en power mi consulta es sobre como puedo hallar la eficiencia en base a horas

[carlosenrique]

tengo un problema tengo una base de datos de un año y mi jefe desea que halle la eficiencia en base a las horas .lo que quiero es por ejemplo si en un filtro selecciono 13/02/2023 a 13/03/2023 quiero un formula para obtener las horas totales que has entre esas dos fechas

[v-rzhou-msft]

Hi @carlosenrique ,

According to your statement, I think your issue should be caused by your data model. I suggest you to share a sample file with us and show us a screenshot with the result you want.

This will make it easier for us to find the solution.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@carlosenrique , Hope you have date and time field or time field.

separate out time and then you can use a table to join an analyze by hours

Time Table
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...