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...
ronrsnfld i have added few more data in this one drive folder of excel file.
data.csv
https://1drv.ms/u/s!AmauTLNmHKexhGk_35S3lYSDxxQs?e=5NcD4K
Could you please check on the same.
Out of town now. But have a method for straight line Interpolation of missing data points ignoring missing data at very start or end. Will post later this week.