Populate most recent cell and copy that value in all remaining cells per project?

[KH11NDR]

Hi Guys

* Copy the latest loaded in Forecast number and and populate the rest of the remaining forecast numbers per project with the last forecast figure, so 100 all the way down to Dec - 2018

ProjectID	Date	Forecast
AAA	01/08/2018	100	* Loaded in
AAA	01/09/2018	100	* Copy the latest loaded in Forecast number and and populate the rest of the remaining forecast numbers per project with the last forecast figure, so 100 all the way down to Dec - 2018
AAA	01/10/2018	100
AAA	01/11/2018	100
AAA	01/12/2018	100
BBB	01/08/2018	200
BBB	01/09/2018	200
BBB	01/10/2018	200
BBB	01/11/2018	200
BBB	01/12/2018	200

[v-danhe-msft]

Hi @KH11NDR,

Based on my test, you could use the "Fill Down" function in Query Editor:

Sample data:

Use the "Fill Down" function and you can see the result.

Regards,

Daniel He

[KH11NDR]

That does work, It's my fault I should of given my full requirement, I need It to fill From current month to the end.  This is filling up previous months up aswell which are empty, I want to fill those with historic data.

[v-danhe-msft]

Hi @KH11NDR,

I could not figure out the historic data you have mentioned in your problem. Could you please post me your desired picture or share your pbix file if possibel?

Regards,

Daniel He