Forum Discussion
Interpolate missing data with group by column
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
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?