Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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
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
up
up
up
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |