Forum Discussion
Interpolate missing data with group by column
Hello All, I would like to have blank values to be filled with interpolated values as per the dates and name column values. Sample data: let
Source = Table.FromRows(Json.Document(Binary...
What kind of interpolation? Linear or something else?
Or just a straight line interpolation between the points surrounding the missing values?
If the latter, how do you want to extend the values for the beginning/end where there is no boundary value?
ronrsnfld straight line interpolation between the points surrounding the missing values is what I'm looking for.