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.
For the straight line interpretation solution, how will you handle the situation where there is no starting value as at the top of your table?
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