Forum Discussion
Calculate Work hours between two differents dates
Hi guys!
I'm looking on the internet and I'm having a hard time finding it on the forums. I would like to know some way to calculate the period in hours worked between two dates using DAX and calculated columns.
Attached is an example dataset, with all tables the account would be simple: Second date minus first date, less weekend, less rest period, less holidays.
Has anyone seen or made some kind of formula like that?
2 Replies
- amitchandak
Super User
jupiterbi , Yet to check the file. Refer to the attached file, if that help for calculation of working days
I'm so sorry, amitchandak . I want to see the results in hours worked.
For example:
05.01 - 18 work hours
08.09 - 25 work hours
09.03 - 3 work hours
...
I have a problem with this dataset, because in Brazil we have a differents holidays. So, I imagine that it's possible with a auxiliar table in this dataset.Can you help me? You can get my file?
