Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |