Select in DateTime Range

[slyfox]

Dear Community,

Have a task to align production execution and registered sensors values during goods production.
One table has the date and time of the start of production and the date and time of the end of production each time a unique product. Another table keeps a log of the values of dozens of different temperature sensors. Logs are recorded in a date and time format, every two seconds. The only possible relationship between the tables is the date and time.

The task is this: when choosing a product in one table, filter the sensor values that were recorded from the beginning of the production of the product to its end. Some kind of select in DateTime range...

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

You should be able to filter out the tables using some of the techniques demonstrated here, but need to be able to see the data and expected result to be more specific:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[slyfox]

Hello @Greg_Deckler 

Here is my pbi file  https://wetransfer.com/downloads/4e987e01997728d0fe1d228aca77f09a20190729145009/aad955a16af440eb8374...

Any of the suggested links do not bring me expected result.

please help 

[slyfox]

up

[slyfox]

up

https://wetransfer.com/downloads/ff6fd05832b20085f116e599cd1c253020190801185033/937a97638fc504f9ce76...

[slyfox]

up

[slyfox]

up