Insert dates missing from table of data

I have a table of fuel prices (Terminal Gate Prices) by date with the following columns:

  1. Date
  2. Product - can be Premium Unleaded, normal unleaded, diesel etc
  3. Price

Some dates are missing - for example a fuel price may be issued on 5 July and this will not change until 9 July, so the table has no dates for the 6th, 7th & 8th days.

What I need it for all dates to be included and the price from 5 July to continue for the missing dates 6, 7 & 8.

Can this be done in Power Query via some sort of fill in?

Yes, this can be done in PQ. Can you upload some sample data? If not, take a look at the List.Dates function



Hi Nick,

TGP table.xlsx (73.8 KB)

Here is the file.


TGP table.xlsx (37.9 KB)

Hi Nick,

I have solved the problem. Your hint for list.dates function gave me the start. This solution is rather complicated so please post if you have a simpler solution.

It seems I needed a start date and an end date column, so I followed this video to get the End date column:

Here is the final result.

Regards, Sergei