Help with filtering on hours between 5pm and 9am inc weekends and holidays

[lennox25]

Hi, 

Can someone help me? I have a table containing information on emails received. Date/Time etc.  I need to create a column/measure on Power Bi where it will filter only to show emails received 'After Hours' Between 5pm and 9am. This must also include weekends and Public Holidays.

[Greg_Deckler · Accepted solution]

@lennox25 Try:

Column = 
  VAR __DateTime = [DateTimeColumn]
  VAR __Hour = HOUR(__DateTime)
  VAR __Result = IF( __Hour >= 17 || __Hour < 9 || WEEKDAY(__DateTime,2) > 5,1,0)
RETURN
  __Result

[lennox25]

@Greg_Deckler Is it possible to add to this by including Public Holidays? Thanks

[lennox25]

@Greg_Deckler Perfect! Thank you 🙂