Calculated table with continous months

[Anonymous]

Hi,

I have a table with discontinous month data like below:

Category	Product	Date	Price
Wellness	Shampoo	Jan 1 2019	100
Wellness	Shampoo	Feb 1 2019	105
Wellness	Shampoo	Apr 1 2019	120
Nutrition	Energy bar	Jan 1 2019	200
Nutrition	Energy bar	July 1 2019	205
Nutrition	Energy bar	Mar 1 2020	225

I want to create a new calculated table with price coming for each month. E.g since March 2019 is not present for Shampoo in Wellness then it should bring previous value 105 of Feb 2019. Basically autofill data from Jan 2019 to March 2021 with previous avaiable values. Similarly for Energy it should fill 200 value for months from Feb 2019 to June 2019 then July 2019 value 205 fro July to Feb 2020. Basically an autofilled table with values from minimum available date in table to maximum available date in table.

[Fowmy · Accepted solution]

@Anonymous 

This sort of operation better be done in Power Query. Refer Attached working file below my signature.

Create a blank Query, go to the Advanced Editor, clear the existing code, and paste the codes give below and follow the steps.