I have a table of fuel prices (Terminal Gate Prices) by date with the following columns:
- Product - can be Premium Unleaded, normal unleaded, diesel etc
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?