Forum Discussion

Catalin_Andrei's avatar
Catalin_Andrei
Regular Visitor
7 years ago

Calculating worked days

Hi all

I am a beginer with Power BI so please be so kind and help me. I have 3 tables :

- Dates 

- Technician 

- Leaves

What I need , is first to calculate how manny working days are in Dates table , and then to calculate the effectivley worked days for each technician which had an leave . 

Thank you in advance for your help!

General Info

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi there,

     

    I did one project similar to this.  The most challenge part is to determine the working days.

     

    What I did was to label which day is weekend in the date table first; after that I have to need to create a holiday table which contains the local/national holiday date in the past/current/future years.  By join the date table and the holiday table, I was able to label both weekend date and holiday date in the date table.  In the end, in the date table, the date without any label is the working date.

     

    Hope it helps.