Forum Discussion
villasenorbritt
Resolver I
Resolver IExcluding Time Frames in Visual when Populating Values with a Measure and Rows with Time Bins
I have a measure that is taking seconds, which corresponds with downtime for a specific machine, and turns it into a duration. Here is the measure : Chelsie Eiden's Duration = // Duration format...
Phew. Create a calendar table that goes down to that level (ie 48 rows per day) and then based your measures on that new calendar table, using EXCEPT and INTERSECT.
villasenorbrittResolver I
Resolver IHalf hour slots is the biggest bin size I can get away with for this.
lbendlin
Super User
Super UserPhew. Create a calendar table that goes down to that level (ie 48 rows per day) and then based your measures on that new calendar table, using EXCEPT and INTERSECT.