Forum Discussion

craigdent's avatar
craigdent
Frequent Visitor
5 years ago
Solved

Calculate working days lost per month

Hi all, I'm hoping someone will be able to help me out.   I am trying to pull some absence reporting into Power BI and one of the measures I need to report on is the total number of working days lo...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Easier said than done.  This turned out to be a monster query.  Please check that the results are as expected and that performance is acceptable.

     

    see attached

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Easier said than done.  This turned out to be a monster query.  Please check that the results are as expected and that performance is acceptable.

 

see attached

craigdent's avatar
craigdent
Frequent Visitor
5 years ago

This looks great, thank you for your time and effort on this!

 

I do get one error though, and it's because some of the end dates are not filled in because the person hasn't returned to work yet. To counter this I added a calculated column to add in today's date if it's blank or provide the end date which worked a treat! Thank you again!

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Yes, I neglected to mention that I cover that scenario in the Power Query portion. Should have done it in DAX via COALESCE().