Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
during
Hi guys,
I am looking for a formula which would allow me to mark opportunities which arise working hours.
I have already created created formula which shows me days of a week Day = FORMAT(MatchedTraders[createdAt Date],"DDDD")
I also have column with Created time
All I need is now a column which says:
In hours opportunities = if [Day] = Saturday or Sunday and [created_Time] 10am to 1pm, if [Day] =Monday to Friday and [created_Time] 8am to 6pm, "in hours", "outside working hours")
Does anyone know how to construct such calculation?
Many thanks in advance
Andre
Solved! Go to Solution.
Try this calculated Column
= IF ( OR ( OR ( MatchedTraders[Day] = "Sunday", MatchedTraders[Day] = "Saturday" ) && HOUR ( MatchedTraders[Created Time] ) >= 10 && HOUR ( MatchedTraders[Created Time] ) < 13, MatchedTraders[Day] <> "Sunday" && MatchedTraders[Day] <> "Saturday" && HOUR ( MatchedTraders[Created Time] ) >= 8 && HOUR ( MatchedTraders[Created Time] ) < 18 ), "in hours", "outside working hours" )
Try this calculated Column
= IF ( OR ( OR ( MatchedTraders[Day] = "Sunday", MatchedTraders[Day] = "Saturday" ) && HOUR ( MatchedTraders[Created Time] ) >= 10 && HOUR ( MatchedTraders[Created Time] ) < 13, MatchedTraders[Day] <> "Sunday" && MatchedTraders[Day] <> "Saturday" && HOUR ( MatchedTraders[Created Time] ) >= 8 && HOUR ( MatchedTraders[Created Time] ) < 18 ), "in hours", "outside working hours" )
Perfect it worked. Thank you!
By the way, you may help accept solution. Your contribution is highly appreciated.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |