See drop missing values

Anonymous · ‎05-10-2019

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?

v-danhe-msft · ‎05-12-2019

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.