Forum Discussion

jupiterbi's avatar
jupiterbi
Frequent Visitor
5 years ago

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 cal...
  • jupiterbi's avatar
    jupiterbi
    Frequent Visitor
    5 years ago

    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?