calculate based on hours

[koralillis]

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

[ray_ux · Accepted solution]

@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")

[amitchandak]

@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

[Dinesh_Suranga]

Hi @koralillis ,

Could you please share your data table with sample data?

Thank you.