Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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 Try:
Column =
VAR __DateTime = [DateTimeColumn]
VAR __Hour = HOUR(__DateTime)
VAR __Result = IF( __Hour >= 17 || __Hour < 9 || WEEKDAY(__DateTime,2) > 5,1,0)
RETURN
__Result
@Greg_Deckler Is it possible to add to this by including Public Holidays? Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |