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 IV
Super User IV

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 

Highlighted
slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

up

slyfox Regular Visitor
Regular Visitor

Re: Select in DateTime Range

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors