Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Identify and condition Weekend days from a big year date data

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 🙂

 

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    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.