No of Days Calculation while separating weekends

[Anonymous]

StaffName	EntryDate	Contractor	TotalHours
arin	1/3/2018 0:00	San Antonia	25.5
adam	1/4/2018 0:00	san Antonia	22.5
agatha	1/5/2018 0:00	AUSTIN	13
Annelie Marcilese	1/8/2018 0:00	Jonestown	7
Mary	1/9/2018 0:00	San Antonia	20
Brad	1/10/2018 0:00	San Antonia	17.5
Brad	1/11/2018 0:00	San Antonia	16
Brian	1/12/2018 0:00	Temple	23
Bry	1/15/2018 0:00	San Antonia	28.5
kaitlyb	1/16/2018 0:00	San Antonia	16
Charles	1/17/2018 0:00	Leander	17.5
Candy	1/18/2018 0:00	Fredricksberg	16
Hunter	1/19/2018 0:00	Z-ALIST	28
Hirt	1/22/2018 0:00	San Antonia	33.5
Kristine	1/23/2018 0:00	Dallas	8.25
John	1/24/2018 0:00	Dallas	35
Dave	1/25/2018 0:00	AUSTIN	8
Dave	1/26/2018 0:00	AUSTIN	18.25
Rob	1/29/2018 0:00	Dallas	26.75
Derrin	1/30/2018 0:00	Temple	8
Shorey	1/31/2018 0:00	Temple	26
Tamy	2/1/2018 0:00	HOUSTON	16
Ellie	2/2/2018 0:00	HOUSTON	16
Emilie	2/5/2018 0:00	AUSTIN	25
Erica	2/6/2018 0:00	San Antonia	16
Jacob	2/7/2018 0:00	BATON	24
Jose	2/8/2018 0:00	San Antonia	38.5
Jose c	2/9/2018 0:00	Dallas	30
Jessie	2/12/2018 0:00	San Antonia	20
jina	2/13/2018 0:00	AUSTIN	6.5
Holy	2/14/2018 0:00	Jonestown	23
Mills	2/20/2018 0:00	Temple	16
Juan	2/21/2018 0:00	HOUSTON	6.75
Timberlake	2/22/2018 0:00	Dallas	28
Ken	2/23/2018 0:00	San Antonia	30.5
Liza	2/26/2018 0:00	Jonestown	16
Marin	2/27/2018 0:00	AUSTIN	19.5
Miranda	2/28/2018 0:00	Dallas	30
Lynn	3/1/2018 0:00	AUSTIN	9.75
Martinez	3/2/2018 0:00	Temple	29.2
omar	3/5/2018 0:00	Jonestown	16
Vicky	3/6/2018 0:00	HOUSTON	21
Philip	3/7/2018 0:00	Fredricksberg	15
Ryan	3/8/2018 0:00	Fredricksberg	16
Sandy	3/9/2018 0:00	Leander	8
Wislom	3/12/2018 0:00	Dallas	26.5
Smith	3/13/2018 0:00	Z-ALIST	16.5
sophia	3/14/2018 0:00	AUSTIN	15
amay	3/15/2018 0:00	AUSTIN	22.5
Taylor Parker	3/19/2018 0:00	MOBILE	24
Peggy	3/22/2018 0:00	Dallas	26.5
Tanya	3/23/2018 0:00	HOUSTON	14.5
Vero	3/26/2018 0:00	HOUSTON	16
Waren	3/27/2018 0:00	Dallas	17.5
Shelly	3/28/2018 0:00	AUSTIN	8.25
Sharon	3/29/2018 0:00	HOUSTON	24.5

I am trying to Calculate no of days while seprating the Weekends.   I have tried few calculations  but none seems to be working.  I would appreciate any help !!

[v-yuta-msft]

Hi Tan,

You may create another calendar table and mask the weekends and holiday using some dax formula, please refer to these blogs:

https://forum.enterprisedna.co/t/number-of-working-days/258/9

https://powerpivotpro.com/2012/11/networkdays-equivalent-in-powerpivot/

Regards,

Jimmy Tao

[Anonymous]

I may not be able to do this is as the data source is SQL

[Greg_Deckler]

So, are you looking for Net Work Days?

https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362

[Anonymous]

Thanks Greg

 I am wanting to calculate no of days based on hours and Entry Date only.  (There is no "Second Date")

The Calculation is based on (total  hours/(no of days(individual has worked(on weekdays and on weekends)* 8))