Forum Discussion
Solved
Hours in Session
On the academmic tracker, you can click on teacher and see how many hours you have taught. It is called "Hours in Session." It says caculates hours from the past seven days. I was told that it is the...
Hi teach2025 ,
Thank you, amitchandak , for your response and for sharing those valuable reference links.
- The tracker might be using the DATEDIFF logic, which usually doesn’t include both the start and end dates. This could explain why you’re seeing a 6-day range instead of 7 days.
- If weekends are not counted, the tracker might be using a business-day calculation like NETWORKDAYS, which only includes working days.
- Some session types, such as homeroom, small groups, or assemblies, might not be counted or are handled differently, depending on how the system is set up.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
teach2025 , The datediff will not include both date. So if you want both, you have to add one day.
For Workdays, you can use networkdays
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
For business Hours - refer
https://exceleratorbi.com.au/calculating-business-hours-using-dax/