Forum Discussion

Anonymous

Not applicable

3 years ago

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

Anonymous

Not applicable

3 years ago

ronrsnfld straight line interpolation between the points surrounding the missing values is what I'm looking for.

ronrsnfld

Super User

3 years ago

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?

Forum Discussion

Interpolate missing data with group by column

Related content

Inferring Missing Columns and Imputing Missing Data

missing data

Total value missing in calculated column

Generating Missing Data

Stop Power BI from interpolating between missing values