Calculating worked days

[Catalin_Andrei]

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!

[amitchandak]

@Catalin_Andrei , Please get the pbix from the link. It has a calendar with working days and same has been used to take date diff

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

Refer to 2nd page for Working day Diff

[Anonymous]

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.