From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Interpolate values

Interpolate values - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Interpolate values

“

- [Instructor] One of the challenges in working with data is there are often gaps in the data measurements. The time zero's visuals on this page represent daily measurements for Los Angeles temperatures and natural gas spot prices. The temperatures in the top chart don't contain any gaps between the data measurements, but the price data in the middle chart does. If we hover over the line chart below, we don't see any gaps in the lines directly, because Power BI draws a straight line between the price on the last day and the price on the next day that the market is open. We can calculate these interpolated prices directly if we want to use them as estimates for the days when the energy markets close. Let's first determine the last date for the price. We need to extend our date range so it goes between the first date of all data points and the current date, which we'll do by applying the dates between time intelligence filter over the contiguous date field from the dates table. We'll…

Contents