Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Categorize data by specific time periods

Hi there, I was wondering how I would go about grouping data by specific time intervals during the week.   Priority is to calculate the data based on the following filters for the below times: Pr...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Try to do like this, please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

FaiyazN's avatar
FaiyazN
Regular Visitor
1 year ago

Hi this was really good but when I implemented to my issue it did not work.  Can some help me with the below. I have date and time struggling to get the same out put as you got.

 

Category below

Peak - Monday to Friday between 05:00 and 16:59

Off-Peak - Monday to Friday between 17:00 and 04:59 (including Monday 00:00 to 04:59 and Friday 17:00 to Saturday 00:00)

Weekends - Saturday 00:01 until Sunday 23:59.