Forum Discussion
Filtering and splitting a value based on date range
Hi Community! So, i have 2 tables containing manufacturing data 1, Runtime table - Contains the Runtime data of machines (start, error, wait etc) with timestamps of each event 2, Work table - C...
Generally the recommendation is to use an INTERSECT() - that is, if you can agree on some sort of granularity level like 5 minute intervals. If you need exact timings then the DAX becomes much more complex. I have similar reports where the logic is so complex that I have to do it outside of Power BI (as a SQL Server scalar function).
Please explain your design requirements/limitations.