Forum Discussion

kleighton's avatar
kleighton
Icon for Helper II rankHelper II
5 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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.