Forum Discussion
Interpolate missing data with group by column
ronrsnfld Is it possible to make it by max and min value's available just like how it is calculated using dax in below link
https://community.powerbi.com/t5/Community-Blog/Linear-Interpolation-with-Power-BI/ba-p/341202
That solution does not show values prior to the first given value. In your table, there are a number of empty values prior to the first known value. That requires extending the trend line. And my question is how do you want to handle that if you are doing a straight line Interpolation between given values?
ronrsnfld Thanks for all the inputs but unfortunately I do not have any idea on how to manage it.
could you please suggest a best method of implementation where we can fill those missing data.
The suggestions would have to do with the shape of the data. I'm sure someone better versed in statistics would have a better idea, but the data you present does not seem lend itself to a least-squares trend.
Here is a graph of your data for the first day:
For where you have one or two blanks within the data, I suppose you could just "connect the dots". But what do you do for the first twelve data points? There is nothing to connect to, and the pattern is not well defined. Although anything can be programmed, you are the one that will need to decide what to do. I don't know of a viable method to interpolate long periods given this kind of data. One or two missing are probably not a problem. But you have much more than that at the start of your data.