Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |