cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slyfox Regular Visitor
Regular Visitor

Select in DateTime Range

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...

6 REPLIES 6
Super User
Super User

Re: Select in DateTime Range

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


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

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.

 

thermal project.png

 

please help 

slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

up

slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

Highlighted
slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

up

slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

up

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 283 members 2,598 guests
Please welcome our newest community members: