Forum Discussion

New Member

4 years ago

Solved

calculate based on hours

How I can calculate based on hours.. for example all the sales of Friday after 10pm should be count as Monday sales

koralillis Something like this. i think that's what you are asking for?

SWITCH(
  TRUE(),
  Day IN {"Saturday", "Sunday"}, "Monday",
  Day = "Friday" && HourOfDay >= 22, "Monday",
  Day = "Sunday", "Monday",
  "WorkWeek")

3 Replies

Icon for Memorable Member rank

Memorable Member

koralillis Something like this. i think that's what you are asking for?

SWITCH(
  TRUE(),
  Day IN {"Saturday", "Sunday"}, "Monday",
  Day = "Friday" && HourOfDay >= 22, "Monday",
  Day = "Sunday", "Monday",
  "WorkWeek")

Dinesh_Suranga
Continued Contributor
4 years ago
Hi koralillis ,
Could you please share your data table with sample data?
Thank you.
amitchandak
Super User
4 years ago
koralillis , In this logic, put an additional filter of 10 AM. OF create a date column, which move you friday date after 10 AM to Monday

https://amitchandak.medium.com/power-bi-show-weekend-data-on-monday-or-friday-dab5ee201f0e

New Date = Switch(True(),

weekDay([Date],2) =5 && Timevalue([Datetime]) >time(10,0,0), [Date]+3,

weekDay([Date],2) =6 , [Date]+2,

weekDay([Date],2) =7 , [Date]+1,

[Date]

)

Now use this new date