Forum Discussion
Interpolation to fill in missing data
Our client has set up multiple sensors to monitor movement and various environmental factors including air temp, structure temp and wind speed. We are wanting to understand the correlation between the air temperature and movement of individual sensors and plot this on a line/scatter graph however, the sensors all record data at slightly different times meaning you never have a complete row of data from all sensors for a specific time period (as shown below). Is there a way to interpolate the data to fill in the null values so a line/scatter graph can be created? (Alternative suggestions welcomed)
1 Reply
Hi nathanhayes ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) Click “transform data” to enter the power query, click “group by”.
(3) Then the result is as follows.
If I misunderstand what you meant, please provide your expected results.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
