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