topic Re: Calculate Work hours between two differents dates in DAX Commands and Tips

Calculate Work hours between two differents dates

jupiterbi — Fri, 27 Nov 2020 01:15:41 GMT

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?

https://we.tl/t-z10mtQj5NA

Re: Calculate Work hours between two differents dates

amitchandak — Fri, 27 Nov 2020 01:53:26 GMT

jupiterbi , Yet to check the file. Refer to the attached file, if that help for calculation of working days

Re: Calculate Work hours between two differents dates

jupiterbi — Fri, 27 Nov 2020 14:48:03 GMT

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?