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 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?