See drop missing values

[Anonymous]

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]

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

[Anonymous]

Anyone?