Forum Discussion
Solved
Create time slicer for multiple overlapping shifts
Hello, I have a Date/Time column in my data source, and I have written a calculated column with 3 IF statements to break up the data into three shifts, basically IF [Date/Time] >= 00:00 and [Dat...
Create a new table for the shifts definitions (per hour) and use it in a many to many with single filter direction relathionship.
Please check this sample file.
Create a new table for the shifts definitions (per hour) and use it in a many to many with single filter direction relathionship.
Please check this sample file.
Brilliant! This is an excellent and simple solution.
Thank you!
My pleasure