Identify and condition Weekend days from a big year date data

[Anonymous]

Hi Guys, 

I'm having trouble handling big data in Power BI. I have a big data from a large set of job information that field workers in a large company did for a year (2019) with a collumn called arrivedate that means the date and hour that the worker starts to work associated with workers. 

Field workers in addition to working during the week also work on the weekend. My data looks like this:

I have data of every single day of every single month of 2019. However, I need to know how many days the field workers worked in 2019 during the weekend days in every month, but I don't know any DAX formula that gives me that information. 

I wnated to filter my field workers working days by:

• Weekdays they work from 8 AM to 6 PM;
• Weekend days they work from 6 PM onwards

Thank you, and I hope you can help me 🙂

[v-juanli-msft]

Hi @Anonymous 

Do you need to calculate the hours every worker works during one year?

working hours are (8AM -6 PM on workday and 6 PM-12 PM on weekend)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

IF(WEEKDAY([Date],3) < 5,"Weekday","Weekend")