Forum Discussion
Anonymous
7 years agoNot applicable
See drop missing values
Hi fam.
I have a couple IoT sensors. I want to know how often does the sensor unit transmit per hour, average over 7 days.
Usually the sensors are set on send per 5 min, 10 min or 15 min. I want to see if the sensors missing/drop/lost values during those 7 days.
I think I have to do a measure with the Datestamp column but don't really in which way it's the best. Do you have any idea or tips how I can do it?
2 Replies
- AnonymousNot applicable
Anyone? :smileyfrustrated:
- v-danhe-msftMicrosoft Employee
Hi Anonymous ,
Could you please post some simple sample data and your desired result to have a test if possible? 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
Regards,
Daniel He