Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to build a statement for the below by shift , but with no luck.
A: Sunday-Tuesday 6:00 am-6:00 pm, Wednesday 6:00 am-Noon = Green Days
B: Wednesday Noon-6:00 pm, Thursday-Saturday 6:00 am-6:00 pm = Yellow Days
C shift Sunday-Tuesday 6:00 pm-6:00 am, Wednesday 6:00 pm-12:00 am = Green Nights
D shift Wednesday 12:00 am-6:00 am, Thursday- Saturday 6:00 pm-6:00 am = Yellow Nights
if Date.DayOfWeek([END_DATE_TIME])=<3 and Time.Hour[END_DATE_TIME])>=6 and Time.Hour([END_DATE_TIME])<16 then "Green Day"
Your help is much appreciated.
Solved! Go to Solution.
Hello,
I wanted to start a new thread since the original thread was solved on my original request.
I am getting an error when trying to insert the dayofweek function.
What is the issue you are getting? Can you share your table structure with sample data.
You can also try SWITCH, true
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |