Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
We have a lot of IoT devices installed.
Some will not send data to cloud due to contact problem/configuration problem.
IoT ID | Voltage | Current | timestamp |
1 | 1 | 2 | 19.01.2023 |
2 | 1 | 2 | 19.01.2023 |
3 | 2 | 2 | 19.01.2023 |
4 | 19.01.2023 | ||
5 | 19.01.2023 | ||
1 | 1 | 2 | 20.01.2023 |
2 | 2 | 2 | 20.01.2023 |
3 | 1 | 2 | 20.01.2023 |
4 | 20.01.2023 | ||
5 | 20.01.2023 |
I would like to have
1. a list of ID (in this case ID 4 and 5) of those IoT devices and count number of IoT devices which is not sending data to cloud
2. exclude those ID numbers in calculation to have better efficiency.
if I do intergral of battery current, I can exclude ID 4 and 5 to save computing data and time.
Thanks in advance!
Best regards
Solved! Go to Solution.
@reynold522 if it is not correct so please share table formate output so we can understand your requirment of output.
thank you for your question
e.g., count number of points with voltage<2 from each IoT ID.
Thanks in advance!
sorry for confusion.
number of rows with voltage <2V
@reynold522 if it is not correct so please share table formate output so we can understand your requirment of output.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |