Need DAX to populate rest of my row

[Anonymous]

Hi,

I have the below DAX: 

LastInv =

Calculate(

Sum('Plan PBI_GTS_SIOP_Supply_Demand'[inventory])

, FILTER(KEEPFILTERS('Plan PBI_GTS_SIOP_Supply_Demand')

, 'Plan PBI_GTS_SIOP_Supply_Demand'[Relative Week]=calculate(MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Week]),'Plan PBI_GTS_SIOP_Supply_Demand'[inventory]>0)

)

)

I need to add to the DAX to populate the future blank row cells with the previous "LastInv" Number in this case 6.74.

I'd appreciate any help thanks,

[ValtteriN]

Hi,

Here is a thread discussing similar topic. I think it might be of
help: https://community.powerbi.com/t5/Desktop/Dax-Repeat-last-non-empty-measure-for-date-sequence/td-p/62...

[Anonymous]

yes definitely some essence of what I'm looking for but was hoping to have some opinions on my current DAX or what's needed to alter it if possibel to achieve my need.

Cheers