Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
I wrote a calculated column I was wanting to use as a filter since break and lunch times should not be counted towards downtime:
Solved! Go to Solution.
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.
what's the biggest bin size you can get away with for this? half hour slots? 15 minute slots? 5 minutes?
Half hour slots is the biggest bin size I can get away with for this.
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.